table help

[mis]

Hi forum members,

I am trying to create a stock control system for a local business which have several stores in different locations. I have come up with the following tables, please could you take a look and offer some help/suggestions.

I have a price issue as i do not know where to place the price field. I would like the stock control system to monitor the prices of the products so that if items go into clearance this can be monitored and recorded.

 

[Pat Hartman]

You should avoid column names such as Name, Date, and Time. They are the names of properties or functions and will cause confusion should you ever need to write any VBA. Be consistant with abbreviations. You have Qty in one place and Quantity in another.

I'm not sure what tblPrice is for. If you want to keep a price history by date, the table needs to include productID as part of its primary key. tblPrice currently has a repeating group - price occurs 3 times. It should only occur once.

 

[mis]

Price

Thanks for your reply,

At current the items are brought into the business and a price is placed on each item, the buisness reduces items into clearance prices a maximum of three times, he would like the system to monitor each of the clearance prices and the date the item went into clearance that is why there is a price table.

??

 

[Pat Hartman]

It should only have 1 price field, not 3.

 

[mis]

Cheers

thanks for the reply makes sence, any other problems or idears for the database.