I have just begun using the set relation commands for relating parent and child tables. This works fantastic except if you don't have any matching child records for the current parent record. If there aren't any matches in the child table then the record pointer is moved to the last record in the child table which can show incorrect data on a form.

For example, if I have a customer history form and I set a relation between the customer and the invoice tables, I could go into a customer that doesn not have any invoices but one will still show, the last invoice in the table.

Is this correct? Is there a way around this? The desired result would be if there aren't any child records don't show ANY records.

Thanks,
Paul