Michael,

>select retail
>skip
>
>I end up skipping to the next record in the child table instead.

How are you setting up the relation? Is this in a form's DataEnvironment, or are you setting the relation in code? If so, please post the code.

Are you using the SET SKIP TO childtable command? That will give you the skip in the child table that you are seeing.