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.