Append query

[sir_dan_mitchell]

hi,I have asked this b4, but il try again. I have a database that creates a table with an append query. When i update the append query there are many duplicate records in the table. I have tried using customer ID as a key field, but this only allows one customer to have one video.I want one customer to have many videos.

as you may have guessed its a video shop

PLEASE HELP ASAP

THANKS

Dan

 

[adz2013]

Is there somthing else that you can use with the Customer ID as a primary key(such as maybe a date/time of when they rented the movie)?

 

[Rich]

If you read the replies and continued with the same post you wouldn't keep getting different answers. You need at least TWO tables One has the customer details the second has the rentals. Did you look at Northwind or Orders sample databases supplied by Microsoft as I advised you? If you don't get your table structure correct you will not be able to sort out the mess.

 

[sir_dan_mitchell]

Can I send you my database and you can see if u can solve it?