1 Reply Latest reply on Jan 25, 2012 2:31 AM by Sorbsbuster

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

    CraigRozelle

      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.