I want to create a custom calculator.
I am prepared with a table that is an array of price values for an array of items at an array of locations.
I imagine creating a form that serves as the calculator. In it, I call up a given location, get the list of items/prices for that location, input quantities for some of the items and get a grand total for the quantities of prices of the quantities of items entered.
I do not want or need to save the quantities each time. I want the calculator form to reset (provide blank quantity fields) each time a location is chosen.
I'm a relative FM amateur, with two projects under my belt. I have yet to use numeric calculation fields in any depth so that is new territory. Any pointers to start would be much appreciated.