"Duplicate output destination" Append Query

ashley1

Registered User.
Local time
Today, 12:12
Joined
Apr 7, 2005
Messages
35
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????
 
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.
 

Users who are viewing this thread

Back
Top Bottom