Page 1 of 1

Unable to update a Relationship Field

PostPosted: Mon Jan 18, 2016 12:43 am
by Marengo
As a stall holder at a Craft Market I want to create a database to record sales, and at the same time record stock levels. Table "Stock" lists items, price, and stock #. Table "Market" lists date, item(Db popup - Stock.item), price(Db popup Stock.price), Running Total of Sales (Calc), and Stock # (relationship: Market.item to Stock.item showing stock#). I am wanting help to reduce Stock.stock# each time a sale is made. I am assuming that same logic would apply to multiple items sold, however I would like to calculate a discount for a multiple sale (1 for $5: 3 for $12).

Thanks for your time in considering this issue.