Filemaker Pro 8.5 Advanced Maintenance TG761Z/A ユーザーズマニュアル
製品コード
TG761Z/A
140 FileMaker Functions Reference
Lookup
Format
Lookup(sourceField{;failExpression})
Parameters
sourceField - the
value is taken.
failExpression - any
Parameters in curly braces { } are optional.
Data type returned
text, number, date, time, timestamp, container
Description
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
.
Example
There are two tables, People and Company, in a
below.
People table
People table
Company table
The People and Company tables are related using the number field CompanyID. The
calculation CompanyName = Lookup(Company::CompanyName;“Not found”)
calculation CompanyName = Lookup(Company::CompanyName;“Not found”)
defined in the People table will return
Apple
FileMaker
for the second
record and
Not found
for the third record.
CompanyID
Employee
100
John Smith
200
Peter Wong
300
Sally Anderson
CompanyID
CompanyName
Code
100
Apple
91234
100
Apple
82345
200
FileMaker
95054