Setting a Field Value by Finding a Field in a 2nd Table
I have a table called "estimate" with fields for "vendor name" and "item description". These fields are populated with drop down lists. I would like to be able to set a field "price" with a value based on searching a second table called "catalog" using the contents of "vendor name" and "item description" as the search criteria. I would like to run a script activated by pressing a button, but I can't seem to get the script right.
You don't need a script to set the price. In the pricelist you will need to have the article ID, the customer name (orID) and the price. You can create a relationship from invoice items to the pricelist table using both those criteria. You can then set the price in the invoice line to be by lookup; that will also allow you to over-ride the price if you want to.