This seems like it should work, but it doesn'. I'm stumped.

SELECT invno, lineno, invitem ;
FROM artran01 ;
INTO TABLE temp ;
WHERE (NOT EMPTY(invitem)) AND (invdte > {12/01/1999})

SELECT temp
INDEX ON invno + STR(lineno,4) TAG invno1
SET ORDER TO TAG invno1

SELECT arytrn01
SET ORDER TO TAG invno1
SET RELATION TO invno1 INTO temp

It's telling me that it can't find variable "invno1".

When I try to set the relation in the datasession window, it doesn't give me the list of indexes to pick from like it does if I try and set the relation on a different table. Is there something wrong with tables created with SQL that makes it so it can't be used in a relation?

Thanks,

Michelle