Lookup

Takes six parameters, FieldBase, Destination, Table, Alias, SourceField, IfLenFld

Description:

This command should only be used lightly, instead using a JoinQuery for heavy work loads.

The purpose of this command is to fetch a single Field Value from a single Record and place it into the destination Field of the current Work Query. Each input parameter can be Field name in your Work Query that holds the Table, Alias, or Source Field Name, or a text literal for those values.

Here are the syntax options:

    FieldBase, Destination, Table, Alias, SourceField, IfLenFld
    [WorkWith], Destination, Table, Alias, SourceField, IfLenFld
    [WorkWith], Destination, Table, Alias, SourceField, [""]
    FieldBase, Destination, Table, Alias, SourceField, [WorkIf]
    [WorkWith], Destination, Table, Alias, SourceField, [WorkIf]

Example:

NewFields            "Date.Received"
Lookup            "Date.Received", "`Biz.Job", `pJob, "`Received", ""
[New] Received | LongDate$ Date.Received

HtmlAlert ("Received: " & Received) 'Received: December 12, 2016