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?
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?
Linking Multiple Linked Fields
0 commentaires:
Enregistrer un commentaire