For this function to access the contents of the source field, the tables containing the source field and
calculation field need to be related. Calculations using the
Lookup function won’t be forced to be
unstored calculations.
The People and Company tables are related using the number field CompanyID. The calculation CompanyName = Lookup(Company::CompanyName;“Not found”) defined in the People table will return
Apple for the first
record,
FileMaker for the second record, and
Not found for the third record.