Linking Multiple Linked Fields

[Inencana]

Hi,

I'm fairly experienced with databases and VBA, but not as much with Access.

I want to create a table where I select a customer and a site. I have made both of these linked fields, and it works.

However I want the site to only show sites relevant to the customer I have selected. i.e. sites that have a customer key equal to the customer key I just selected in the Customer key field.

I have had a play, but cannot work out how to do this. Any hints?

 

[KingBroil]

Hi,
I'm fairly new to all of this, but I had to do something similar once. Have you read about cascading comboboxes in a form? It let you see only the choices that are relevent to the previous combo box selection, very useful and there's a lot of information about this on the web. Back then I just had to copy/paste some code and adjust a little bit to make this work.

 

[Cronk]

Inencana,

Assuming you have tblCustomers with a key field CustomerID, tblSites with a key field of SiteID, and a join table containing CustomerID and SiteID.

Then a query will give you sites for a particular customer.

Or am I not understanding what you really want?