Subform Problem

J

jason.kohout

Hello,

I'm kind of new to access, but I cannot seem to find the solution to
this problem in any books.

The problem is that I have "individuals" who are each part of different
"groups." Individuals can belong to different groups. My solution is
to have three tables: Individuals, Groups, and table that simply has
the linking information:

Group1-Individual1
Group1-Individual2
Group2-Individual2
.....

How can I make a subform work so that I can work with individuals on my
main form, and then my subform can be a list of groups the individual
is in?

Thanks,

Jason Kohout
[email protected]
 
D

Duane Hookom

Set the Record Source of your subform to [table that simply has the linking
information]. In the subform, add a combo box bound to the group field and
set its Row Source property to [Groups].
 
Top