relatedrecordid( function

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

addrelatedrecord -- adds a new record to the related database corresponding to the current database.
fieldvalue( -- grabs the contents of a field in the current record of a database. You can grab data from the current database, or from another database.
findrelated -- finds information that matches the current record in a related database.
formulavalue( -- calculates the result of a formula based on data in the current record of any open database. This is similar to the fieldvalue( function, but allows any formula to be used, rather than just a single field.
globaldictionarybuild -- builds a global dictionary by scanning a database.
join -- joins data from another database into the current database.
Join Databases -- joining another database into the current database (relational join).
joinonerecord -- joins matching data from another database into the current record.
lastlookupdatabase( -- returns the name of the database referenced in the most recent lookup.
Linking with Another Database -- techniques for relating multiple database files so that they work together.
lookup( -- searches a database for a value, then returns other information from the same record. For example, the *lookup(* function can look up a phone number given a customer name, or look up a price given a part number.
lookupall( -- builds a text array containing one item for every record in the target database where the data in the keyField matches the keyData. Each item in the text array contains the value extracted from the dataField for that record. If the data field is a numeric or date field, it is converted to text using the default patterns for that field.
lookupalldouble( -- is similar to the lookupall( function, but it returns two fields from the target database instead of just one.
lookupalloctet( -- is similar to the lookupall( function, but it returns eight fields from the target database instead of just one.
lookupallquadruple( -- is similar to the lookupall( function, but it returns four fields from the target database instead of just one.
lookupallquintuplet( -- is similar to the lookupall( function, but it returns five fields from the target database instead of just one.
lookupallseptuplet( -- is similar to the lookupall( function, but it returns seven fields from the target database instead of just one.
lookupallsextet( -- is similar to the lookupall( function, but it returns six fields from the target database instead of just one.
lookupalltriple( -- is similar to the lookupall( function, but it returns three fields from the target database instead of just one.
lookuplast( -- searches the selected records in a database for a value, then returns other information from the same record. For example, the *lookuplast(* function can look up a phone number given a customer name, or look up a price given a part number. Unlike the lookup( function which searches from the top of the database, the *lookuplast(* function searches backwards from the bottom.
lookuplastselected( -- searches the selected records in a database for a value, then returns other information from the same record. For example, the *lookuplastselected(* function can look up a phone number given a customer name, or look up a price given a part number. Unlike the lookupselected( function which searches from the top of the database, the *lookuplastselected(* function searches backwards from the bottom.
lookupmoredata( -- looks up an additional data field based on the previous lookup.
lookupmoreformula( -- looks up additional data based on a previous lookup.
lookupselected( -- searches the selected records in a database for a value, then returns other information from the same record. For example, the *lookupselected(* function can look up a phone number given a customer name, or look up a price given a part number.
posttorelated -- posts data in the current record to the corresponding record in a related database.
related( -- searches a database for a record in a related database that matches the current record in the current database based a relational specification (based on one or more key fields or formulas in each database), then uses a formula to return other information from the same record. This is similar to the lookup( function, but instead of using an individual field for the key, a relation is used (see Relational Database Management).
relatedarray( -- builds an Text Array by scanning a database and creating an array element for every record that matches a relational specification (based on one or more key fields or formulas). This is similar to the arraybuild( function, but instead of using an individual field for the key, a relation is used (see Relational Database Management).
Relational Database Management -- linking together multiple databases based on common data.
Relational Workshop -- tool that assists in composing relational lookup(, superlookup(, lookupall( and arraybuild( functions.
selectrecordsrelatedto -- selects records in the current database that are related to any record in another database.
selectrelated -- selects information that matches the current record in a related database.
serverlookup( -- searches a shared database for a value, then returns other information from the same record. Similar to the lookup( function, but the search is performed on the server instead in the local computer's memory.
superlookup( -- searches a database for a record that matches a query formula, then uses a second formula to return other information from the same record. This is similar to the lookup( function, but instead of using an individual field for the key and data, any valid true/false (Boolean) formula can be used.
table( -- searches a database for a value, then returns other information from the same record. Unlike the lookup( function, the *table(* function does not require an exact match. If it does not find an exact match the *table(* function will use the closest match. For example, the *table(* function can look up a tax rate given an income amount, or look up a shipping price given a zip code and weight.

History

Version	Status	Notes
10.2	New	New in this version.