I am building a partners mgt database for my company and I am stuck with how to create a data entry form that will serve different tables in a many-to-many relationship.
I also need to to design an MS Access form interface that users can use to query the db based on different criteria
The main table is the tblPartners table which stores data of partner companies and is linked to 6 other tables in a many-to-many relationship:
One such table is the tblClients table which will store a list of different clients for each of the partners in tblPartners
One partner can have one or many clients and one client may be doing business with one or many partners.
Data Entry
———–
1. How do I create a form that users will use to select one or more client for each partner?
Reporting
———-
2. How do I create another form that users will use to query the database to generate custom report. For example, to retrieve all partners for a particular client.
Thanks for your help. Hope I am clear.
