Get

Takes two parameters, TableName, IfLenFld

Usage:

TableName, IfLenFld
TableName, [""]

Description:

Append additional fields from another record into the current record. It is required that the target record's Alias is currently in memory or else an error will be returned instead.

Note: This command will overwrite data in existing fields in the work query with data from the table, if those fields exist in the table. To avoid overwriting data, you could use the Get command in a separate Query or Method, keep only the desired fields, and use JoinQuery; you could also use the Lookup command if you only need one or two fields from the table.

Example:

Rem 'Add the Finance.Account record data for each Item
    SetNew      "Finance.Account.Alias", `AccAlias
    Get         "Finance.Account"
     
    HtmlTable
EndRem