Linking with Another Database
This page is currently incomplete, but you can find information about this topic at the links below:

- deleteall -- The deleteall statement removes all records, leaving a single blank record.
- deletechildren -- The deletechildren statement deletes all the records in another database that have a value in the key field that is equal to the key value.
- deleterecchildrenwarn -- The deleterecchildrenwarn statement warns you before deleting the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- deleterecordandchildren -- The deleterecordandchildren statement This deletes the current record from the active database and all the records in another database that have a value in the key field that is equal to the key value.
- fieldvalue( -- The fieldvalue( function 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.
- lastlookupdatabase( -- The lastlookupdatabase( function returns the name of the database referenced in the most recent lookup.
- lookup( -- The lookup( function 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( -- The lookupall( function 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( -- The lookupalldouble( function is similar to the lookupall( function, but it returns two fields from the target database instead of just one.
- lookupalloctet( -- The lookupalloctet( function is similar to the lookupall( function, but it returns eight fields from the target database instead of just one.
- lookupallquadruple( -- The lookupallquadruple( function is similar to the lookupall( function, but it returns four fields from the target database instead of just one.
- lookupallquintuplet( -- The lookupallquintuplet( function is similar to the lookupall( function, but it returns five fields from the target database instead of just one.
- lookupallseptuplet( -- The lookupallseptuplet( function is similar to the lookupall( function, but it returns seven fields from the target database instead of just one.
- lookupallsextet( -- The lookupallsextet( function is similar to the lookupall( function, but it returns six fields from the target database instead of just one.
- lookupalltriple( -- The lookupalltriple( function is similar to the lookupall( function, but it returns three fields from the target database instead of just one.
- lookuplast( -- The lookuplast( function 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( -- The lookuplastselected( function 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( -- The lookupmoredata( function looks up an additional data field based on the previous lookup.
- lookupmoreformula( -- The lookupmoreformula( function looks up additional data based on a previous lookup.
- lookupselected( -- The lookupselected( function 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.
- superlookup( -- The superlookup( function 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( -- The table( function 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
1.0 | Updated | Carried over from Panorama 6.0, with some updates.