That's the least of the kinds of problems you'll run into trying to work with SBT. In my (limited) experience, it's a real mess...


>That's it! Thanks. I guess it always worked by coincidence before because I would give the index the same name as the field and never used a compound index before. Dang SBT...
>
>Thanks,
>
>Michelle
>
>
>>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
>>