Create a dropdown box that allows me to choose from another dropdown box.

[LonnieCAR]

I downloaded a generic order entry template for Access and manipulated it to create forms for production and purchase orders. I am still finalizing how it will print my forms. However, my holdup is that I would like to choose my customer and then have it allow me to choose from a list of up to 10 different shipping locations specific to that customer. Each time I try to generate queries or tables to link to my form it either locks-up, will not let me select from the list, or simply will not work. I have attached a compressed copy of where my database file stands and would greatly appreciate any assistance. I will likely have other questions but need to move forward, as this has been a bottleneck for me for the past couple of days.

[June7]

Perhaps you want dependent comboboxes. Review http://www.datapigtechnologies.com/f...combobox2.html

You have tblShipToAddress with 10 fields for addresses. Then Customers also has 10 fields for addresses. Neither of these is normalized structure. This just confuses me. How do you envision this arrangement should work?

If you want to associate up to 10 addresses for each customer, then should have a related table that will have a record for each address for each customer.