OfficeFrustration - View Single Post

**John W. Vinson** · February 11th, 2010, 02:34 AM posted to microsoft.public.access.tablesdbdesign

On Wed, 10 Feb 2010 17:50:01 -0800, JD Steiger JD
wrote:

I am trying to create a membership database for a church.

I need to have all members entered into the database, then for the members I
need to have their spouse name and anniversary, and the names of their
children. I am trying to get a subform for each of these into the main form,
but when I try to use it it just shows the spouse in the first spot as the
spouse for every record.
I need to lock or bind this information to each "Master" form.
So that joe smith at 123 anyplace somewhere usa will show his spouse and
children while joe smith at 456 somewhere anyplace usa will show his spouse
and children also the spouse's page (jane smith) will show joe smith as her
spouse with their children.
I would also like to hyperlink the spouse name so that if you click it their
record will be pulled up.

Anyone that can help me with this endeavor would be greatly appreaciated.

The way I've done this is to have a "Household" table related one-to-many to a
"Members" table. The address is stored in the household table; it lets you
search for a member and will bring up a form with that member's household on a
subform.

If you would like a free, open code copy of the database, drop me an email at
jvinson at wysard of info dot com.
--

John W. Vinson [MVP]