Uodate Query Help

[armyofdux]

So i have a database that tracks an enrolls persons into classes. The class shell data is in a tbl named Slotting. I then have a table with all the students in it. This tbl is titled Students. What I want is to match shell data to a respective student and combine the info, the shell data is located in tbl Course Data. The data is all in the same format between tables (IE. Short text, number, etc). I think this is best done with an update query but it never seems to actually update the destination table. I have been using the below example here but it never copies/updates anything.



https://support.office.com/en-gb/art...5-f6769d2bb717

Tbls
Slotting
Students
Course Data

Fields
LAST
FIRST
MIDDLE
SLOT_ID

[NTC]

I don't really follow your post - particularly 'shell data'...but in general: an Update query is used to overwrite data into existing records while an Append query is used to create new records.

The textbook database example of a school has tables: students, classes - and then it is the 3rd table Assignments that one uses Look Up field types to link to the other 2 tables.