Append query

[Guest]

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

 

[tina]

each EventDate in tblAttendance is linked to a specific individual in
tblIndividuals, by the common IndividualID field in both. so if you want to
append a record to tblAttendance, you have to supply an EventDate value AND
an IndividualID value, so the event date will be linked to an individual.

hth