Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 8

  

|

  Logical functions     141

LookupNext(sourceField;lower/higherFlag)

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.

text, number, date, time, timestamp, container

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 

There are two tables, People and Company, in a 

below.
People table

100

John Smith

200

Peter Wong

300

Sally Anderson

377

Mary MacKenzie

100

Apple

91234

100

Apple

82345

200

FileMaker

95054

300

Motorola

93456

400

Cisco

88123