Unable to update a Relationship Field

For HanDBase related topics that are not specific to one platform.

Unable to update a Relationship Field

Postby Marengo » Mon Jan 18, 2016 12:43 am

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.
Marengo
 
Posts: 1
Joined: Sun Jan 17, 2016 8:47 pm

Return to HanDBase General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest