Takes two parameters, TableName, IfLenFld
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.
Rem 'Add the Finance.Account record data for each Item
SetNew "Finance.Account.Alias", `AccAlias