>I am having trouble comming up with error free syntax for the lookup() command. I am trying to use fields to return a value on a report. I have two tables (contacts & Issues). So far, I have an expression for a field on my report as: lookup(issues.cissues, contact.iissueid, issues.iissue_id, "ISSUEID"). This only gives me various errors, i.e. "Alias issues is not found" even though they exist in the data environment.
>
>Am I missing a set of quotes somewhere? Any ideas?
>Mike
Try the third parameter without the alias:
lookup(issues.cissues, contact.iissueid, iissue_id, "ISSUEID")
Erik Moore
Clientelligence