Asking for Subdatsheet after adding extra relationship

[duffy180788]

I have 2 relationships between 3 tables,

Customer Table > Customer ID (pk) 1
Issues Table > Customer ID (FK) Many
Complaints Table > Customer ID (FK) Many

Each table has Customer ID as you can see, I have linked the Customer ID From Issues & Complaints table to the Customer ID field to the Customer Table using a 1 to Many relationship.

Am creating a form on the customers table so an admin can add a customer issue against the customer this is working fine, The trouble is when I link the Complaints table as well. its asking for subdatasheets.

Am I doing something wrong?

regards

craig

 

[Pat Hartman]

You can't use the Complaints table in the same query. It needs to be a separate query and separate subform since it is not related to Issues (or is it?)

Should Issues and Complaints be in the same table with a type code to distinguish them?