relatedrecordid(
SOURCEDATABASE
)

The relatedrecordid( function returns the record id of a record in a related database that matches the current record in the current database based on a relational specification.


Parameters

This function has one parameter:

sourcedatabase – is the name of the source database. This database must be open.


Description

This function returns the record id of a record in a related database that matches the current record in the current database based on a relational specification (a relational specification is based on one or more key fields or formulas in each database, see Relational Database Management).

This example uses the releatedrecordid( function and the findid statement to find the customer record associated with the current customer in the current database (for example an order entry database).

let id = relatedrecordid("Customer List")
if error
    message "Customer not found"
    return
endif
topwindow "Customer List"
findid id

See Also


History

VersionStatusNotes
10.2NewNew in this version.