Hi,
In my solution the first table would have a unique number for just the
household.
You could have a unique number for each member in the 2nd table.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: <
[email protected]>
| Sender: <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: Club Membership Database
| Date: Wed, 14 Jul 2004 08:11:59 -0700
| Lines: 138
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRptOjNh3CiggO3Q6C+S86bZehwdw==
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.setupconfig:30657
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| Hello Eric!
|
| After printing and reading your response (and digesting
| it), will your solution allow all the family members to
| each have a unique member number? After all, they're
| still individual members, just grouped under the "head of
| household". Just as it would be for spouses or sig
| others. We actually have TWO members, just one household.
|
| Thanks!
|
| Sandy
|
|
| >-----Original Message-----
| >Hi Sandy,
| >
| >Why not have a Master table that has the following
| >
| >ID# HHFirstName HHMiddleInitial
| HHLastName HH(other key
| >field if needed)
| >-------- ---------------- -------------------- -
| ---------------
| > --------------------------------------
| >1 John
| H. Doe
| > xxxxx
| >2 Mary
| W. Wilson
| > xxxxx
| >3 Peter
| K. Jones
| > xxxxx
| >
| >
| >Then in your other table where you have everyone's name
| listed have the
| >following:
| >
| >ID# FirstName LastName etc..
| >------ ------------- -------------- ---
| ----------
| >1 John Doe
| xxxxx
| >1 Sue Doe
| xxxxx
| >1 Mike Doe
| xxxxx
| >2 Mary Wilson
| xxxxx
| >2 Bob Wilson
| xxxxx
| >
| >And of course you can choose not to enter the HH name
| twice in the 2nd
| >table or not.
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
[email protected]
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><
http://www.microsoft.com/security/security_bulletins/ms03
| -026.asp> and/or
| >to visit Windows Update at
| <
http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Sandy" <
[email protected]>
| >| Sender: "Sandy" <
[email protected]>
| >| Subject: Club Membership Database
| >| Date: Tue, 13 Jul 2004 11:59:34 -0700
| >| Lines: 18
| >| Message-ID: <
[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| thread-index: AcRpC4l2f0XFSyoHQ3CzXMaNURBCJw==
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Newsgroups: microsoft.public.access.setupconfig
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.access.setupconfig:30644
| >| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| >| X-Tomcat-NG: microsoft.public.access.setupconfig
| >|
| >| Hello Everyone!
| >|
| >| I'm trying to set up an Access DB to keep track of all
| the
| >| members in my local hiking club. I have a database
| >| already set up, but I'd like to "link" records. For
| >| instance, a family membership that has 1 husband, 1
| wife,
| >| and 3 children. I'd like to have a "master" record,
| then
| >| when I bring up that master record, it will bring up
| the
| >| other three members. There ARE four members and each
| has
| >| their own member number. I just want a way that when I
| >| bring up one record (say the husband), it will also
| have
| >| the wife and three children listed.
| >|
| >| Is there a way to do this?
| >|
| >| Thanks for your help!
| >|
| >| Sandy
| >|
| >
| >.
| >
|
