"Duplicate output destination" Append Query

[ashley1]

Hiya

im trying to add new records from one table to another, this will be done on a weekly basis.

What i need to do is add new records to exisitng table according to Student Number, but because the same student can apply to many courses i need to allow duplicates

I get error "Duplicate output destination" Student Code
Is there a way around this????

 

[neileg]

I think you need to review your design. You have a many to many relationship between students and classes. The proper way to implement this is using a junction table. Do a search on many to many or junction tables. There's plenty of help in these forums.