Filemaker Pro 8.5 Advanced Maintenance TG762Z/A ユーザーズマニュアル
製品コード
TG762Z/A
Chapter 8
|
Logical functions 141
LookupNext
Format
LookupNext(sourceField;lower/higherFlag)
Parameters
sourceField - the
value is taken.
lower/higherFlag - the keywords lower or higher denote whether the value from
the next lower/higher matching
must be taken if the lookup fails.
Data type returned
text, number, date, time, timestamp, container
Description
Returns the value specified in sourceField using the
in the
. If the lookup fails, the value from the source field in the next lower or higher
matching record will be returned, as specified by lower/higherFlag. In order for this
function to access the value in sourceField, the
need to be related. Calculations using the LookupNext function won’t be
Example
There are two tables, People and Company, in a
below.
People table
People table
Company table
CompanyID
Employee
100
John Smith
200
Peter Wong
300
Sally Anderson
377
Mary MacKenzie
CompanyID
CompanyName
Code
100
Apple
91234
100
Apple
82345
200
FileMaker
95054
300
Motorola
93456
400
Cisco
88123