stocktake option

[izen]

Hi there
I would like to do stocktake option in my database
I have a product table that has productID, product name, price/Unit and supplierName.

What I have done is:

I have done create another table which is stocktake table that has stocktakeID, ProductID and stocklevel. after that I craated the stocktake form and I add producttable and stocktake table (sub form of product table) the problem is productID in product table and productID in stocktake table has one to many relationship. I dont want to have one to many I want to have one to one. how can I do ?

or or just simply put the stocklevel field in the product table? and use the query to calculate the cost of each product

thanks guys

 

[pbaldy]

There's some methodology discussed here:

http://allenbrowne.com/AppInventory.html

Having the multiple records keeps your historical data. If you didn't care about that, I'd probably just add the date and stock level fields in the products table.

 

[izen]

thank you for your answer