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
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
