Manage Many:Many Relationships

[mapondera]

I have several many:many relationships for my main table PRODUCTS. PRODUCTS ProductID and CUSTOMER CustomerID are linked in a 1:many relationship as foreign keys, and together form a concatenated primary key for the table PRODUCT_CUSTOMER_RECORDS. I have about 6 such relationships all related to PRODUCTS.

Problem:
1. How do I create a form based on these tables.
2. How can I program a "duplicate record" command for this form without getting a "run time error" all the time.
3. How do I filter these records

Someone told me that I need to base this on a query but how? The other child tables are all independent of each other but all have the same parent table PRODUCTS in common.

 

[LQ]

To create a form from a query, all you have to do is first create a query that contains all the tables that you need. Then if you switch to the forms tab and click on New, you can choose your query from a drop down list at the bottom of the New Form dialog box (it says "Choose the table or query where the object's data comes from"). After that, you pretty much create the form in the same way you create a form based on a table.