Customers With Multiple Addresses - How to list and select correct address on form?

[Sandboxer]

I am not a coder, so please bear with me while I attempt to explain in only the surface language of Access. I have created a form to input all information about each of my customers. The base form is "Customers". On top of this I have layered several subforms onto tabs.

The first tab is "contacts" The contacts tab subform contains all information about a particular contact; phone numbers, email, etc. I want to be able to select, from a list, the contact's address. However:

- Customers can have more than one address
- An address can belong to more than one customer

I created a Junction Table with two primary keys "Customers" and "Addresses" for this many to many relationship situation.

What I envision is an option group made up of all potential addresses for that contact's company; I was able to do that, but the result was merely a datasheet view of all the addresses for that customer. What I want to be able to do is to say "contact 1" is located at "address 2" (or 15, or 46, e.g.) and click a checkbox or something to indicate this relationship.

My first go-round was to add a Address Field to my contacts table from which I would select their address. The problem is how do I limit the list to only the one or two addresses applicable?

Thanks for your time. =^..^=

[Rabbit]

It sounds like you're talking about Cascading Combo/List Boxes. Take a look at the tutorial and see if that's what you need.

[Sandboxer]

It sounds like you're talking about Cascading Combo/List Boxes. Take a look at the tutorial and see if that's what you need.

It appears to be ... I printed out the tutorial and am going to give it a try. Thank you. 8^)

[Rabbit]

Good luck, let us know how you get along.