How do I make a hierarchy of combo drop-down boxes?

[lonniepoet]

I have a database I have been working on for a couple of weeks now and I need to get this thing done ASAP because my boss is hounding me. I am just shy of paying someone to build the rest of it for me. My problem is as follows:



On my main form I would like to have two drop down boxes. One for a customer's name and then another one that gives me up to 10 different shipping addresses for that specific customer.

There are other things I'd like to accomplish and may even ask for help on, but this is (and has been for 5 days) my major roadblock. I attached a copy of my unfinished work for anyone brave enough (or nice enough) to build this thing without having to explain it right quick. However, a list of readable instructions for an Access novice (dummy really) would be good too.

Thanks!
-Very Frustrated (not really... the name's Lonnie)Corner Post OMS v1.0.zip

ps. I also posted in the main Access forum. I am going to try all angles here to get this sucker done...

[pbaldy]

Is this what you're after?

http://www.baldyweb.com/CascadingCombo.htm

I deleted your quadruplicate threads. Please don't post the same question multiple times.

[lonniepoet]

Sorry, didn't mean to break any rules or offend with the multiple posts. I have a form that populates a query/table by entering multiple addresses for the same customer each time I add a new customer. How could I use the philosophy mentioned in your answer to create a similar combo box scenario? One where I can enter multiple addresses and then access them on my master form per each customer. Thanks again btw.

[pbaldy]

I'm not clear what you're trying to do. The most common way to maintain that type of relationship is a form/subform, where the form is bound to a customer table and the subform is bound to an addresses table. They would be related by a customer ID. The technique I posted is more used when you're trying to search for an address or something, so you can narrow down the selections.

[lonniepoet]

Are there any examples you can show me? Or would you be so kind to build something simple or edit my attachment. I am completely lost here. I couldn't thank you enough.

[pbaldy]

I hadn't looked at your sample. The way you're storing addresses isn't normalized. When you can have multiple, there should be a related table, just like your orders and order details tables.