Question Locked

Access 2003 Question

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I've created a database where I can log different IT issues in order to track and turn into the CEO quarterly. 90% of it works great, the problem is that I'm getting Error 3101 The Microsoft Jet database engine cannot find a record in the table with key matching field(s) .

I'm using a combo box to pull data from a table.

Here's the SQL View script:
SELECT NewContacts.ID, NewContacts.[First Name] & " " & NewContacts.[Last Name] AS Expr1
FROM NewContacts
ORDER BY NewContacts.[Last Name] DESC;

I'm lost as to what to do, there are two contacts in the table and it can save to one, and not the other. Please help!

2 replies

by rkuhn040172

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.

This discussion is closed to new replies.