ANY HELP? (1 Viewer)

[sir_dan_mitchell]

Hey people,

Have any of you ever tried 2 create a video shop database? I am trying 2 create one and cant seem 2 solve a certain problem.

I have a purchase table, that's updated with an append query. I want the append query to stop repeating records, but i still want to be able to let one customer buy more than one item of stock. HELP PLEEEAASE

 

[Rich]

Why do you not take a look at the "Orders" sample db supplied by MS it's not that far removed from the db your attempting to create.