Hi,

To reiterate Debra's question - when you pick a Customer # how does Excel
know which one of the three ship to addresses to use?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"klafert" wrote:

I am using data validation and this is working. But, now I have one more
thing to do question. I want the Phone number to pop up in another area on
the form. I assume that I have to put the phone number in a separate column.

Example: I have a customer number I use to match and it pulls up the 3 Ship
To Address that works just fine, but after I choose the address if I want the
phone number associated with the Ship To address I have chosen to show up a
few lines down and not pop up the phone number for all 3 Ship To Address is
that possible?

Right now I use the same customer Id for all related Ship To address for this
one customer. I know that if I use a different code like

W224A = SHIP TO ADDRESS 1
W224B = SHIP TO ADDRESS 1
W224C = SHIP TO ADDRESS 1

This would work and pop up the phone number associated with each Ship To
Address for each code but however I want the display to be W224 and not show
W224A, W224B, ETC.