Invno1 isn't a fieldname in arytrn01, is it? It's just the name of an index, right? SET RELATION needs a relation expression, not the index name from the parent table. I think your relation nees to look something like this:

SET RELATION TO (invno + STR(lineno,4)) INTO temp

>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