Append query



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?





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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question