Insert Calculated Result [Select; Globals::number; Products::part_num]
Set Field [Globals::number; Products::part_num]
Insert requires that the target field be present on the current layout while Set Field does not.
You can actually move data several different ways between your two tables:
- A global field like you describe is one.
- You can also use Set Variable and store the info in a variable
- You can also pass the information in a script parameter
All are slightly different ways of putting your data in a "bucket" so that you can carry it to a different record than the record that was originally current.
Thus, these are common ways to move data around when you switch to a different record and/or to a layout that refers to a different table occurrence (show records from in Layout setup...).
"why I could not just jump between databases and search the product numbers?"
Filemaker evaluates references to tables and fields from the context of the current record of the current layout. When you switch layouts, you may now have a different current record from a different table. Before you changed layouts, a reference to Products::part_num referred to the part_num field of the current record. After you switched, it refers to the part_num field of the first record that is already related to your current Invoice_lines record and this may well be a completely different record or such a related record may not even exist.
Great, many thanks the situation is much clearer. Superb description.
Ohh to know a snippet of your Filemaker knowledge.