Lookup

[timepiece]

Hi there, considering myself slightly above newbie (FM) I am stuck with the problem of getting a lookupvalue (number) from another table in the same db. the function inserted refuses absolutely to produce results and is continously balking: The specified field cannot be found. I am using/referencing the field from the account/field list of the table involved. The formula looks like this: "Lookup ( Accounts::Commission_Discount {; 999} )".Can anyone help me with some enlightenment? Appreciate very much any hint to guide me on the right path!

[comment]

Try

Lookup ( Accounts::Commission_Discount ; 999 )

[timepiece]

Only in words: Thanks very much! I am very relieved.