I have a database in access which has a main table and a products table. They are linked by a customer I.D. field (Primary Key).
I have 2 forms one is the customer form and one a products form there is a button to open the products form from the customer form.
I would like to be able to open the products form and have it display the data related to the customer form, That is, all the data is related but displayed on seperate forms.
Can anyone tell me how to do this?
I have the tables linked and I thought that's all I would need to do, but I guess not.