AnsweredAssumed Answered

Setting a Field Value by Finding a Field in a 2nd Table

Question asked by CraigRozelle on Jan 25, 2012
Latest reply on Jan 25, 2012 by Sorbsbuster

Title

Setting a Field Value by Finding a Field in a 2nd Table

Post

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.

Outcomes