>If you use SET RELATION and your parent does not find a child
>to match on, does SET RELATION return something to let me know the status or will the pointer move to the end of record or what?

The child table will be positioned at EOF() on parent records without at least one matching child.