Yes, quite a mess. I finally got to see version 6. It still sucks.

Thanks,

Michelle


>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
>>>