Asking for Subdatsheet after adding extra relationship

duffy180788

New member
Local time
Today, 14:56
Joined
Jun 18, 2013
Messages
7
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
 
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?
 

Users who are viewing this thread

Back
Top Bottom