table setup help

[dcorleto]

I have the following that needs to be created in table:

Stock
Quantity
Price
Amount

The Stock is tape and could be VHS, Beta, or Other
The Quantity could be any number between 1 and 10, however, (and here's where I get confused)....

The Price is as follows - Quantity of (1) is one price, Quantity of (2-10) is another price.

Amount is just the Quantity X price.

Could someone help on how I would start to set this up? Thanks in advance

 

[hneal98]

You have an Item table that would have the item and the unit price and the 2-10 price. So in other words, you would have two fields for the price. Then you would have a stock table with a Item id and quantity of the item.

 

[dcorleto]

ok I have created the tables - Now I would like to put together a form whereby when the user selects the Stock and the quantity, the proper Amount shows and it calculates the total of each line item and then a subtotal. Is this possible?

 

[hneal98]

yes. you would have your main form based on your Stock items and then two subforms, one for the items and the quantity and then the other below that based on the totals.

They should all link by the stock item.