I'm coming up against this error, and really struggling to work it out. Googling reveals very little for this error, so it must be something really simple and stupid that I'm missing. Can anyone help?
The error: "The current field must match the join key '?' in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value and then make the entry with the desired join key in the 'many-only' table."
I understand what that means, but can't find what's causing it.
For debugging (or trying to!), I have recreated a much simplified version of my database with just the relevant tables, query and forms (see attached). I've removed all VBA from this, so there are no distractions in that. The problem still occurs.
It is a main form and a subform. The main form shows the organisation, the subform shows people from that organisation who have registered for an event. The subform is based on a query
The forms are linked by ID on the main form and OrganisationID on the subform.
The error arises when I try to select a person attending. The only event that traps the error is the On Error event. When I debug using a breakpoint in that, [ID] on the master and [OrganisationID] on the child match.
Rather than me rambling on further, see the attached database (I'm using Access 2016 and the file is in *.accdb format)
The error: "The current field must match the join key '?' in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value and then make the entry with the desired join key in the 'many-only' table."
I understand what that means, but can't find what's causing it.
For debugging (or trying to!), I have recreated a much simplified version of my database with just the relevant tables, query and forms (see attached). I've removed all VBA from this, so there are no distractions in that. The problem still occurs.
It is a main form and a subform. The main form shows the organisation, the subform shows people from that organisation who have registered for an event. The subform is based on a query
Code:
SELECT tbl_PeopleRegistrations.*, tbl_People.OrganisationID
FROM tbl_PeopleRegistrations INNER JOIN tbl_People ON tbl_PeopleRegistrations.PeopleID = tbl_People.PeopleID;
The error arises when I try to select a person attending. The only event that traps the error is the On Error event. When I debug using a breakpoint in that, [ID] on the master and [OrganisationID] on the child match.
Rather than me rambling on further, see the attached database (I'm using Access 2016 and the file is in *.accdb format)