calculation that performs a lookup
I have a quotes/quote line items/inventory database setup. Most of the time, I want the quote line items to perform an autolookup on the price. However, in a couple of situations, I want the database to look up the price and then perfrom a calculation on it, based on previous input from the user.
I'm figuring I need to perform a calculation with a lookup, but don't know what the syntax would be.