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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!