>>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 .
Maybe I should of paid more attention to your lecture on 'Grids on Steroids' @ FoxTeach 96.
Thanks for the help Jim
Claude
Claude Gosselin