Takes one parameter, in the form of: Table|{Alias}|Field

Description:

Used to lookup a single Field value from a database record, or return a list of Field values. Same rules and options as the [L] Field Attribute.

    Lookup$ Table|{Alias}|Field
    Lookup$ "Table|{Alias}|Field"

The use of quotes is optional.

Example:

[New] JobStatus = Lookup$ ("Biz.Job|" & pJob & "|Status")

Html ("Job status: " & JobStatus) 'Job status: New