>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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.