Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Lookup(sourceField{;failExpression})

sourceField - the 

 value is taken.

failExpression - any 

Parameters in curly braces { } are optional.

text, number, date, time, timestamp, container

Returns the contents of sourceField, using the 

 in the 

. 

The result of the optional failExpression will be returned if the lookup fails. In order 

for this function to access the contents of the source field, the 

 containing the source 

 need to be related. Calculations using the Lookup function won’t 

.

There are two tables, People and Company, in a 

below.
People table

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 

 for the second 

record and 

 for the third record.

100

John Smith

200

Peter Wong

300

Sally Anderson

100

Apple

91234

100

Apple

82345

200

FileMaker

95054