N
Novice2000
Hi,
I have a data entry form that displays data from 3 tables, the main client
table and 2 archived data tables. The main client table has more records than
the two archived tables, including new clients.
The primary key is the client ID number. Data is retrieved and displayed in
the form including archived data, but when I go to enter a new client number
in the form I get this message:
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 then have to enter the new client number directly into the Client table
before I can go back and use the data entry form to enter any other data. Was
using the client number as the primary key for the three tables a mistake,
since they are not one-to-one relationships? How can I repair this? Thanks
I have a data entry form that displays data from 3 tables, the main client
table and 2 archived data tables. The main client table has more records than
the two archived tables, including new clients.
The primary key is the client ID number. Data is retrieved and displayed in
the form including archived data, but when I go to enter a new client number
in the form I get this message:
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 then have to enter the new client number directly into the Client table
before I can go back and use the data entry form to enter any other data. Was
using the client number as the primary key for the three tables a mistake,
since they are not one-to-one relationships? How can I repair this? Thanks