I keep getting the error:
"The Microsoft Access database engine cannot find a record in the table 'tblClients' with key matching field(s) 'client ID'",
and Microsoft says that the reason for this error is:
"In a one-to-many relationship, you entered data on the "many" side for which there is no matching record on the "one" side. For example, this error occurs if you join a Customers table and Orders table on a CustomerID field, and then add an order using a CustomerID that does not exist in the Customers table."
We have a form (pulls from a query on the Clients table) and a subform (pulls from a query on the CallLog table) that are connected on the clientID and we keep getting this error. As far as I can tell, we should not be getting this error because there wouldn't even be any data in the subform if there wasn't a matching ClientID on the Clients table (main form).
Does anyone have any ideas about this?
"The Microsoft Access database engine cannot find a record in the table 'tblClients' with key matching field(s) 'client ID'",
and Microsoft says that the reason for this error is:
"In a one-to-many relationship, you entered data on the "many" side for which there is no matching record on the "one" side. For example, this error occurs if you join a Customers table and Orders table on a CustomerID field, and then add an order using a CustomerID that does not exist in the Customers table."
We have a form (pulls from a query on the Clients table) and a subform (pulls from a query on the CallLog table) that are connected on the clientID and we keep getting this error. As far as I can tell, we should not be getting this error because there wouldn't even be any data in the subform if there wasn't a matching ClientID on the Clients table (main form).
Does anyone have any ideas about this?
Comment