Hi All,

I am a new Access user and having a mental block concerning queries. What I am trying to accomplish is selecting Ship To address from a list of Shp To addresses in a combo box. I would then enter selection on the invoice. Most of my customers have more then one Ship To address.

Here is the current setup. I have separate Customer and Ship To tables. Every Ship To address is assigned the same ID number as customer ID. If customer ID is “AL100” then all Ship To’s for that customer will have “AL100” as ID number.

What I want to happen first is, Select customer to invoice. Then Select “Ship To” address from a combo box. All Ship To for that customer would be displayed in the combo box. I have been trying without success to create a query to filter all ID’s for that customer.

Thanks for your help.

Daryl

Sorry I placed this in wrong fourm...I'll resubmit in Access Fourm.

Thanks