Append queries (1 Viewer)

[sir_dan_mitchell]

Hi I have a problem with my database.I have an append query creating another table in my database. The database is designed to be used in a video shop. I previously asked on here how I could prevent the repeating records from appearing in the appended table. I was told to put customer ID as a key field...This worked, however I cannot repeat the customer more than once now, so a customer cannot have more than one purchase now. Is there any way I could change this???

PLEASE HELP ASAP

 

[sir_dan_mitchell]

Can anyone help on this?

 

[dkirk02]

Dan-
What you have to do is identify what piece of information should be unique for each record. For instance, if I am placing an order for three items, but you don't want duplicate lines for each item, then the item number would be the unique identifier. That would be the field you would place the primary key on.