K
KLP
An append query adds data to an existing table.
Is it possible to add data to a table that is linked to another table? To
work, the append query would also have to update the ID number, as follows:
Individual Table:
Individual ID
Attendance Table
Event Date
Individual ID
I ran an Append Query to add dates to the Event Date field in the Attendance
Table; result - 0 rows appended, because the individual ID field wasn't
appended also.
Any ideas?
Kelvin
Is it possible to add data to a table that is linked to another table? To
work, the append query would also have to update the ID number, as follows:
Individual Table:
Individual ID
Attendance Table
Event Date
Individual ID
I ran an Append Query to add dates to the Event Date field in the Attendance
Table; result - 0 rows appended, because the individual ID field wasn't
appended also.
Any ideas?
Kelvin