loop up based on one common field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables that I want to merge on to on view screen. The records
on one table will have a unique record to the common field while the other
will have the same field list many times.
I would like to enter the common field and then display all of the
information on to a display of some kind from both tables.

Any suggestions would be greatful!!!
 
hi,
a little confused here but what you wrote sounds like a
simple 2 table single parameter select query.
did i misunderstand something?
 
I have two tables that I want to merge on to on view screen. The records
on one table will have a unique record to the common field while the other
will have the same field list many times.
I would like to enter the common field and then display all of the
information on to a display of some kind from both tables.

Any suggestions would be greatful!!!
Click to expand...

Create a Form based on the "one" side table. Use the Subform Wizard in
the toolbox to create a Subform based on the "many" side table. That's
exactly what this situation calls for!

John W. Vinson[MVP]
 
Back
Top