>>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?
>
>Don
>
>It's the child rec's you're skipping through, and you want the related parent to display, right?
>In the DE, delete the reln. line and reinstate it the other way round, i.e. artificially make the parent the child of the child, by drawing a line from the child's parent fk to the parent's pk. Then all you should need in your vcr button is skip.
>
>HTH
>
>Terry
Actually I want the skipping to stop when the child table reaches the last record that belongs to the parent. Cetin's suggestion will probably work but I'll have to add some code to my VCR set.
Thanks for your thoughts.