stock control project

[illusion]

hello,
i have 2 problems,

1 how the stock control will work? I found similar posts saying to calculate the items sold and compare them with items in stock. When there is restocking the items in stock field will be increased?

2 i want to store the total amount paid from a customer in each order. I searched the posts for this case and the answer always says you shouldn't store calculated values but calculate them each time. In my case the prices for a product might change and user wants to know the total amount received from a customer for different purposes i.e discount, promotion e.t.c

 

[illusion]

hello,
i missed a link (http://allenbrowne.com/AppInventory.html) in a post, this is very helpful but i have a problem,
instead of the list box you said i am using text boxes.
I have
TblProducts(ProductId,UntiPrice....)
TblProduntsOrdered(ProductId,OrderId,Qty,UnitPrice)

how i will assign the TblProducts.UntiPrice to the TblProduntsOrdered.UnitPrice ?

thanks

 

[illusion]

Thanks a lot!!

Most of the things you changed i don't know how to because i am new to access....

 

[jmorgan@seaga]

Wicked

That's a smart little database there Pat - is there anyway of creating an excel project that works in the same way?