>It isn't possible since my parent table doesn't have the adjuster_id field.
>
>Claude

Claude,

It is perfectly possible, the parent table doesn't need the adjuster_id field. Yours is a common misunderstanding about how relations work. A relation is an implicit seek going on in the child table. The seek is using the RelationalExpression to find a record or records in the child table using the ChidlOrder index tag. VFP does partial string matching on the seek. So the SEEK comp_id will find the matches in an index on Comp_id + Adjuster_id and the records will be subordered on Adjuster_id.

Of course you could work alot harder to get the result if you want to <g>.