You must make sure that the tables you set relation into, already have the matching ORDER set correctly, before you issue the SET RELATION commands.

>My actual code is:
>
>

>SELECT luInsPln
>SET ORDER TO ipk
>SET RELATION TO	iAddrCity	INTO luCity,;
>		iAddrSt		INTO luState,;
>		iAddrZip	INTO luZip,;
>		iCarr		INTO luCarr
>
>SELECT Policy
>SET RELATION TO iInsPln INTO luInsPln
>
>SELECT mmPolCse
>SET ORDER TO iCase
>SET RELATION TO iPatRel INTO luPatRel,;
>		iPolicy INTO Policy
>
>SELECT Case
>SET RELATION TO ipk INTO mmPolCse
>SET SKIP TO mmPolCse
>SET ORDER TO ipk
>SEEK ThisForm.nCase IN Case
>

>
> I noticed that the Microsoft VFP Help example is doing the same thing- it doesn't restrict the Child records to only the ones the match the Parent record until you open the Parent in a Browse window and select a record.
>
>Jerry