AUTO ENTER A FIELD VALUE BASED UPON THE ENTRY OF SPECIFIC FIELD IN A LAYOUT
Hi, I am new to FileMaker and the Forum.
I wonder if anyone might be able to help me with a Script Trigger & Script.
OBJECTIVE: Automatically enter the Unit Price for a selected Part Number.
TABLES:: Two; Estimate Data & Part Catalog
LAYOUT: One; Estimate Data
VERSION: FileMaker Pro 12 Advanced
The Part Number is entered into the Part Number field in Estimate Data Layout and I am trying to pull Unit Price from the Parts Catalog Table.
I believe the Script Trigger to use is OnObjectSave and I have pulled this Script Trigger together with Script steps, however, I can't seem to get it to work.
Can anyone help?