Find name on the many side

[johnb]

Hi All
In Acc2003 I have a form and subform that are based on 2 tables with a 1 to
many relationship. Which is the best way to find say a name that stored in
the many side table?

TIA
johnb

 

[John W. Vinson]

Hi All
In Acc2003 I have a form and subform that are based on 2 tables with a 1 to
many relationship. Which is the best way to find say a name that stored in
the many side table?

TIA
johnb

By using an appropriate query for your table structure... which you haven't
posted so it's hard to say.

Basically you'll need some sort of search to find the name in the "many" side
table, use it to identify the record (or records) in the "one" side table, and
open the form filtered to show those records.