I have a parent/child form that is designed to display only one child record at a time. There is a VCR button set to skip through the child records. The problem is the VCR will skip the child table past the parent table record. I thought the child records that don't match the parent record were no supposed to be available when a relationship is set but this doesn't seem to be the case when you
select childtable
skip
select parenttable
I suppose this could be resolved by setting a filter on the childtable to match the parent table record but this seems clumsey to me. Is there a better way?