Duplicates... err... annoying.. Help

[Palern]

Okay here is my PROBLEM:

I've been making an access database for a friend of mine. He is gonna use the database in his store, mainly for registering customers and what they buy..

I have made a scheme consisting of Customer info etc. and a part-scheme were the goods are to be registered. I also need date to be in my part-scheme for later reports.
Each item in the store got its own item number. this is were the problem occurs. I need to be allowed to register the products (same item numbers) several times, but I cant because of duplicates.. I've tried to change the index options in the table, but it wont let me as I cant change it as long as it is primary key :-(

Pls. I need help

 

[mrichards]

You need to keep the items sold in a separate table. ie

Item, quantity, price, cutstomer, date, id.

item = item #
price = price at time of sale
customer = cust#
date = date of sale
id = transaction # (key field) (auto number)

this way you have your cust# and item# numbers unique.


Mark