LOOKUP in SQL server version

[Jai_(Guest)]

Hi,__ I am recreating a Xbase (ver10) report in Sql server (ver10). In Xbase the relationship uses LOOKUP. Sql server version does not have this function. Using table join leads to duplication of records as the table on right has multiple instances of the check value from the table on left. I just need to make sure that the value exists in the table on right with a specific "status" value in atleast one record ( there could be multiple records of the same check value with the same status). I could do this in query and store into a table before reading into R&R. This would mean creating a physical table for every such report. But can we do this directly in R&R Sql version? Any help is greatly appreciated. Thanks in advance.____Jai____

[kfleming]

There is no equivalent to the lookup function in the SQL version. Maybe there is a way to get there via a User SQL but I have only limited SQL expertise so cannot give any good ideas of how it might be done.____Kathleen__R&R Support