Circular Query?

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

Guest

OK, I not too sure if what I'm doing is too ambitious: I have a table of
members and in this table, there is a field called familyid which means that
members belonging to the same family will have the same familyid. In addition
there is a familyrole field that I can specify a husband or a wife.

I'm trying to print a church directory where it lists all members' names and
their addresses which is simple enough. But I also need to print out their
spouse's name as well. How do I create something like this: if member that is
being printed has a familyrole=husband, look for other members with the same
familyid and has a familyrole=wife and similarly if member that is being
printerd has a familyrole=wife, to print member that has familyrole=husband
of the same familyid.

Thanks.
ck
 
Thanks for reading but please ignore this question cos I manage to work it
out somehow (couple of hours of trial and error using query in design mode).
ck
 
Back
Top