How do I setup a form to display info from 3 tables assoc by name

E

Ellen

I have 3 tables of information. Each has a person's last & first names. I'd
like a form to select an individual from table 1 then display any data from
tables 2 & 3 where the individuals first & Last name match. What is the best
way to accomplish this?
 
J

Jim Bunton

As long as you don't want to change the data the easiest way is to create a
query from the 3 tables [joining them].

Then create a form based on the query.

Alternatively you can create a main form on the first table then 'subforms'
on the second two.

(or a combination of the two! - one main form with a joined query of the
second and third tables in 1 subform instead of two)
 
E

Ellen

Is the suggestion then to use a single query with nested joins? or Would
it be easier to create a main form on the first table and then 2 subforms?
Would the subforms give more control over the displayed data?
--
Thanks in advance,
Ellen


Jim Bunton said:
As long as you don't want to change the data the easiest way is to create a
query from the 3 tables [joining them].

Then create a form based on the query.

Alternatively you can create a main form on the first table then 'subforms'
on the second two.

(or a combination of the two! - one main form with a joined query of the
second and third tables in 1 subform instead of two)
Click to expand...
 
Top