Hi,
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 main form and a products form there is a button to open the products form from the main form.
I would like to be able to open the products form and have it display the data related to the main 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.
Thanks
Don