Cascading combo box hierarchy help

[LonnieCAR]

I have a database for work I am on stuck on and need help with badly. On my main form I have a button which loads a table with customer information. I would like this form to populate the table with up to 10 different shipping addresses for each customer. Then, I’d like on my main form to be able to select a specific customer from a drop down box and then have a list of up to 10 different shipping addresses for that customer. I have seen videos on how to do this for cities and states, but this configuration is a little bit different. I am in desperate need of help here. Even willing to pay someone if it has to come down to it. Thank you in advance for any assistance on this issue. I attached the DB as a zip file for tinkering.

[RuralGuy]

Are you using a Form/SubForm arrangement? I have not reviewed your db yet.

[lonniepoet]

I have a subform/form but not for this particular setup. I am not sure how exactly to place it in there.

[RuralGuy]

Is your table of Shipping Address related to your customers some way?

[LonnieCAR]

They need to be related so that I can choose them specifically for each customer. I have a list of shipping addresses in the row for each customer and I assigned relationships to other tables, but I am just so unsure of what I'm doing at this point.

[RuralGuy]

If you create a Form that shows the Customer and then put a SubForm on it that shows the "Shipping Addresses" and put the linking field in the LinkChild/MasterFields properties, then the SubForm will only display the Shipping Addresses of the current customer in the MainForm.

[LonnieCAR]

And will it save so if I pull-up the customer again it shows the same set of addresses? Thanks !

[RuralGuy]

It gives you a form from which you can select the address you want and then save it where you need to.