Displaying subrecords

[George Too]

Hello all,
What is the best way to display subrecords or related data when using a subform in datasheet view?
I have a main form which has the subform in datasheet view. This subform displays my records. I would like to display other related data somehow somewhere but I'm not sure of a way to do it.

Any ideas?

Thanks,
George

 

[smercer]

The way I have mine is insert a subform in the form that is data sheet view and then you can click on the plus sign and you can see the subrecords for each record. if you want them all to be displayed on open, in the subform properties under format tab change "Subdatasheet Expanded" to yes.

 

[George Too]

Thanks for your replies. I was working on something similar to Pat's second suggestion but I was thinking on putting it to rest in light of a better way. I guess this is one of them. Thanks again guys. I'm sticking to it.

George