Creating a membership database

Discussion in 'Access Table Design' started by JD Steiger, Feb 11, 2010.

  1. JD Steiger

    JD Steiger Guest

    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.
     
    JD Steiger, Feb 11, 2010
    #1
    1. Advertisements

  2. 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]
     
    John W. Vinson, Feb 11, 2010
    #2
    1. Advertisements

  3. JD Steiger

    Steve Guest

    Open the main form in design view. Select the subform control. Open
    properties and go to the Data tab. Set the Linkmaster and Linkchild
    properties to MemberID. The subform will now only show the data in the
    subform for the member in the main form.

    If you want help with yur database, I can help. I provide help with Access,
    Excel and Word applications for a very modest fee. I can get your database
    up and running quickly for a very reasonable fee. Contact me to begin using
    your database soon.

    Steve



    "JD Steiger" <JD > wrote in message
    news:...
    >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.
     
    Steve, Feb 11, 2010
    #3
  4. On Thu, 11 Feb 2010 12:56:29 -0500, "Steve" <> wrote:

    >Open the main form in design view. Select the subform control. Open
    >properties and go to the Data tab. Set the Linkmaster and Linkchild
    >properties to MemberID. The subform will now only show the data in the
    >subform for the member in the main form.
    >
    >If you want help with yur database, I can help. I provide help with Access,
    >Excel and Word applications for a very modest fee. I can get your database
    >up and running quickly for a very reasonable fee. Contact me to begin using
    >your database soon.


    Sorry, Steve, I've already sent them my FREE church membership database.

    Some of us have ethics.
    --

    John W. Vinson [MVP]
     
    John W. Vinson, Feb 11, 2010
    #4
  5. "Steve" <> wrote in message
    news:%...
    > Open the main form in design view. Select the subform control. Open
    > properties and go to the Data tab. Set the Linkmaster and Linkchild
    > properties to MemberID. The subform will now only show the data in the
    > subform for the member in the main form.
    >
    > If you want help with yur database, I can help. I provide help with
    > Access, Excel and Word applications for a very modest fee. I can get your
    > database up and running quickly for a very reasonable fee. Contact me to
    > begin using your database soon.
    >
    > Steve
    >






    Stevie is our own personal pet troll who is the only one who does not
    understand the concept of FREE peer to peer support!
    He offers questionable results at unreasonable prices.

    These newsgroups are provided by Microsoft for FREE peer to peer support.
    There are many highly qualified individuals who gladly help for free. Stevie
    is not one of them, but he is the only one who just does not get the idea of
    "FREE" support. He offers questionable results at unreasonable prices. If he
    was any good, the "thousands" of people he claims to have helped would be
    flooding him with work, but there appears to be a continuous drought and he
    needs to constantly grovel for work.

    John... Visio MVP
     
    John... Visio MVP, Feb 11, 2010
    #5
  6. church member database

    Hi All, I am also creating a church database. I was doing the same thing. Head of House table and dependant table. It was working fine but I read somewhere that for greater normalization of my database i might want to take another approach. Namely a complete member table and another table that has adresses ( which tend to be unique to the household) But I'm getting caught up in how the dependants can be connected to this unique address table primary key.

    Am I thinking about this all wrong? Should I go back the master /dependant tables?

    Thanks for any help.
    Lisa Missenda



    JD Steiger wrote:

    Creating a membership database
    10-Feb-10

    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
    need to have their spouse name and anniversary, and the names of thei
    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 th
    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 an
    children while joe smith at 456 somewhere anyplace usa will show his spous
    and children also the spouse's page (jane smith) will show joe smith as he
    spouse with their children
    I would also like to hyperlink the spouse name so that if you click it thei
    record will be pulled up

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

    Previous Posts In This Thread:

    On Wednesday, February 10, 2010 8:50 PM
    JD Steiger wrote:

    Creating a membership database
    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
    need to have their spouse name and anniversary, and the names of thei
    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 th
    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 an
    children while joe smith at 456 somewhere anyplace usa will show his spous
    and children also the spouse's page (jane smith) will show joe smith as he
    spouse with their children
    I would also like to hyperlink the spouse name so that if you click it thei
    record will be pulled up

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

    On Wednesday, February 10, 2010 9:34 PM
    John W. Vinson wrote:

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

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

    John W. Vinson [MVP]

    On Thursday, February 11, 2010 12:56 PM
    Steve wrote:

    Open the main form in design view. Select the subform control.
    Open the main form in design view. Select the subform control. Ope
    properties and go to the Data tab. Set the Linkmaster and Linkchil
    properties to MemberID. The subform will now only show the data in th
    subform for the member in the main form

    If you want help with yur database, I can help. I provide help with Access
    Excel and Word applications for a very modest fee. I can get your databas
    up and running quickly for a very reasonable fee. Contact me to begin usin
    your database soon

    Stev


    On Thursday, February 11, 2010 1:12 PM
    Stop$teve wrote:

    Remember ???
    Remember ??

    "I judiciously chose who to offer fee-based help to based on whether it appears highly unlikely that the poster will get a solutio
    from the newsgroup.

    Get lost $teve. Go away... far away...

    Again... Get lost $teve. Go away... far away...
    No-one wants you here... no-one needs you here..

    This newsgroup is meant for FREE help..
    No-one wants you here... no-one needs you here...
    OP look at http://home.tiscali.nl/arracom/whoissteve.html
    (Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it is a shame !!)

    Arno R

    On Thursday, February 11, 2010 1:58 PM
    John W. Vinson wrote:

    Sorry, Steve, I have already sent them my FREE church membership database.
    Sorry, Steve, I have already sent them my FREE church membership database.

    Some of us have ethics.
    --

    John W. Vinson [MVP]

    On Thursday, February 11, 2010 3:26 PM
    John... Visio MVP wrote:

    Stevie is our own personal pet troll who is the only one who does
    Stevie is our own personal pet troll who is the only one who does not
    understand the concept of FREE peer to peer support!
    He offers questionable results at unreasonable prices.

    These newsgroups are provided by Microsoft for FREE peer to peer support.
    There are many highly qualified individuals who gladly help for free. Stevie
    is not one of them, but he is the only one who just does not get the idea of
    "FREE" support. He offers questionable results at unreasonable prices. If he
    was any good, the "thousands" of people he claims to have helped would be
    flooding him with work, but there appears to be a continuous drought and he
    needs to constantly grovel for work.

    John... Visio MVP


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    WPF Binding Beyond the Limitation of Name Scopes
    http://www.eggheadcafe.com/tutorial...f-49faac8854c8/wpf-binding-beyond-the-li.aspx
     
    Lisa Missenda, May 4, 2010
    #6
  7. Re: church member database

    On Tue, 04 May 2010 13:16:44 -0700, Lisa Missenda wrote:

    >Hi All, I am also creating a church database. I was doing the same thing. Head of House table and dependant table.

    It was working fine but I read somewhere that for greater normalization of my
    database i might want to take another approach. Namely a complete member
    table and another table that has adresses ( which tend to be unique to the
    household) But I'm getting caught up in how the dependants can be connected to
    this unique address table primary key.

    My church membership database (you're welcome to a free copy if you're
    interested, just email me at jvinson <at> wysard of info <dot> com) has a
    Families table related one to many to a Members table:

    tblFamily
    FamilyID <autonumber primary key>
    SortName <last name or other name for sorting>
    DisplayName <e.g. "Mr. & Mrs. Joe Jones", "The Benson Family", "Tim Roberts
    & Mary Jones">
    <address, phone, email, etc.>

    tblPeople
    MemberID <autonumber primary key>
    FamilyID <Long Integer fk to Families>
    MemberNum <optional "giving envelope number">
    LastName
    FirstName
    MiddleName
    Suffix

    There's no "head of family" - everyone in the family is on the same level.

    I included a "MoveOut" button on the Members subform which takes a person and
    creates a new record in tblFamilies and assigns them to that new FamilyID
    (e.g. when a child moves out on her own).

    --

    John W. Vinson [MVP]
     
    John W. Vinson, May 4, 2010
    #7
  8. JD Steiger

    John Price Guest

    Re: It was working fine but I read somewhere that for greaternormalization of

    Hi all,

    I have created an access 2007 database for our carers membership. We are a non-profit organisation supporting and advocating for foster carers.

    I am learning very quickly how access databases function, and need a sample to show me the relationship which will allow me to link spouses, or members residing under the one address.

    Is your database using families tables still available for me to view? (last post here was over a year ago.)

    It would be very much appreciated.

    John

    > On Wednesday, February 10, 2010 8:50 PM JD Steiger 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.



    >> On Wednesday, February 10, 2010 9:34 PM John W. Vinson wrote:


    >> The way I have 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]



    >>> On Thursday, February 11, 2010 12:56 PM Steve wrote:


    >>> Open the main form in design view. Select the subform control. Open
    >>> properties and go to the Data tab. Set the Linkmaster and Linkchild
    >>> properties to MemberID. The subform will now only show the data in the
    >>> subform for the member in the main form.
    >>>
    >>> If you want help with yur database, I can help. I provide help with Access,
    >>> Excel and Word applications for a very modest fee. I can get your database
    >>> up and running quickly for a very reasonable fee. Contact me to begin using
    >>> your database soon.
    >>>
    >>> Steve
    >>>



    >>>> On Thursday, February 11, 2010 1:12 PM Stop$teve wrote:


    >>>> Remember ???
    >>>>
    >>>> "I judiciously chose who to offer fee-based help to based on whether it appears highly unlikely that the poster will get a solution
    >>>> from the newsgroup."
    >>>>
    >>>>
    >>>> Get lost $teve. Go away... far away....
    >>>>
    >>>> Again... Get lost $teve. Go away... far away....
    >>>> No-one wants you here... no-one needs you here...
    >>>>
    >>>> This newsgroup is meant for FREE help..
    >>>> No-one wants you here... no-one needs you here...
    >>>> OP look at http://home.tiscali.nl/arracom/whoissteve.html
    >>>> (Website has been updated and has a new 'look'... we have passed 11.000 pageloads... it is a shame !!)
    >>>>
    >>>> Arno R



    >>>>> On Thursday, February 11, 2010 1:58 PM John W. Vinson wrote:


    >>>>> Sorry, Steve, I have already sent them my FREE church membership database.
    >>>>>
    >>>>> Some of us have ethics.
    >>>>> --
    >>>>>
    >>>>> John W. Vinson [MVP]



    >>>>>> On Thursday, February 11, 2010 3:26 PM John... Visio MVP wrote:


    >>>>>> Stevie is our own personal pet troll who is the only one who does not
    >>>>>> understand the concept of FREE peer to peer support!
    >>>>>> He offers questionable results at unreasonable prices.
    >>>>>>
    >>>>>> These newsgroups are provided by Microsoft for FREE peer to peer support.
    >>>>>> There are many highly qualified individuals who gladly help for free. Stevie
    >>>>>> is not one of them, but he is the only one who just does not get the idea of
    >>>>>> "FREE" support. He offers questionable results at unreasonable prices. If he
    >>>>>> was any good, the "thousands" of people he claims to have helped would be
    >>>>>> flooding him with work, but there appears to be a continuous drought and he
    >>>>>> needs to constantly grovel for work.
    >>>>>>
    >>>>>> John... Visio MVP



    >>>>>>> On Tuesday, May 04, 2010 4:16 PM Lisa Missenda wrote:


    >>>>>>> Hi All, I am also creating a church database. I was doing the same thing. Head of House table and dependant table. It was working fine but I read somewhere that for greater normalization of my database i might want to take another approach. Namely a complete member table and another table that has adresses ( which tend to be unique to the household) But I'm getting caught up in how the dependants can be connected to this unique address table primary key.
    >>>>>>>
    >>>>>>>
    >>>>>>>
    >>>>>>> Am I thinking about this all wrong? Should I go back the master /dependant tables?
    >>>>>>>
    >>>>>>>
    >>>>>>>
    >>>>>>> Thanks for any help.
    >>>>>>>
    >>>>>>> Lisa Missenda



    >>>>>>>> On Tuesday, May 04, 2010 5:01 PM John W. Vinson wrote:


    >>>>>>>> It was working fine but I read somewhere that for greater normalization of my
    >>>>>>>> database i might want to take another approach. Namely a complete member
    >>>>>>>> table and another table that has adresses ( which tend to be unique to the
    >>>>>>>> household) But I am getting caught up in how the dependants can be connected to
    >>>>>>>> this unique address table primary key.
    >>>>>>>>
    >>>>>>>> My church membership database (you are welcome to a free copy if you are
    >>>>>>>> interested, just email me at jvinson <at> wysard of info <dot> com) has a
    >>>>>>>> Families table related one to many to a Members table:
    >>>>>>>>
    >>>>>>>> tblFamily
    >>>>>>>> FamilyID <autonumber primary key>
    >>>>>>>> SortName <last name or other name for sorting>
    >>>>>>>> DisplayName <e.g. "Mr. & Mrs. Joe Jones", "The Benson Family", "Tim Roberts
    >>>>>>>> & Mary Jones">
    >>>>>>>> <address, phone, email, etc.>
    >>>>>>>>
    >>>>>>>> tblPeople
    >>>>>>>> MemberID <autonumber primary key>
    >>>>>>>> FamilyID <Long Integer fk to Families>
    >>>>>>>> MemberNum <optional "giving envelope number">
    >>>>>>>> LastName
    >>>>>>>> FirstName
    >>>>>>>> MiddleName
    >>>>>>>> Suffix
    >>>>>>>>
    >>>>>>>> There is no "head of family" - everyone in the family is on the same level.
    >>>>>>>>
    >>>>>>>> I included a "MoveOut" button on the Members subform which takes a person and
    >>>>>>>> creates a new record in tblFamilies and assigns them to that new FamilyID
    >>>>>>>> (e.g. when a child moves out on her own).
    >>>>>>>>
    >>>>>>>> --
    >>>>>>>>
    >>>>>>>> John W. Vinson [MVP]
     
    John Price, May 15, 2011
    #8
  9. Re: It was working fine but I read somewhere that for greater normalization of

    On Sun, 15 May 2011 13:57:13 GMT, John Price <>
    wrote:

    >Hi all,
    >
    >I have created an access 2007 database for our carers membership. We are a non-profit organisation supporting and advocating for foster carers.
    >
    >I am learning very quickly how access databases function, and need a sample to show me the relationship which will allow me to link spouses, or members residing under the one address.
    >
    >Is your database using families tables still available for me to view? (last post here was over a year ago.)
    >
    >It would be very much appreciated.


    Answered in email.
    --

    John W. Vinson [MVP]
    Microsoft's replacements for these newsgroups:
    http://social.msdn.microsoft.com/Forums/en-US/accessdev/
    http://social.answers.microsoft.com/Forums/en-US/addbuz/
    and see also http://www.utteraccess.com
     
    John W. Vinson, May 15, 2011
    #9
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Bill Boynton

    Membership Database

    Bill Boynton, Jun 25, 2004, in forum: Access Table Design
    Replies:
    1
    Views:
    76
    Steve Schapel
    Jun 26, 2004
  2. Sandy

    Membership Database Structure

    Sandy, Jul 13, 2004, in forum: Access Table Design
    Replies:
    1
    Views:
    139
    Guest
    Jul 14, 2004
  3. Graham

    Membership database

    Graham, Dec 14, 2004, in forum: Access Table Design
    Replies:
    4
    Views:
    117
    Jeff Conrad
    Dec 15, 2004
  4. Lynn Trapp

    How do I include member photos in a membership database?

    Lynn Trapp, Mar 25, 2005, in forum: Access Table Design
    Replies:
    0
    Views:
    92
    Lynn Trapp
    Mar 25, 2005
  5. pav55

    Club Membership Database

    pav55, Apr 9, 2005, in forum: Access Table Design
    Replies:
    3
    Views:
    172
    Duane Hookom
    Apr 9, 2005
  6. johnedc

    How do i setup a membership database?

    johnedc, May 24, 2005, in forum: Access Table Design
    Replies:
    1
    Views:
    85
    johnedc
    May 24, 2005
  7. tlyczko

    Viescas membership database multiple member rates???

    tlyczko, Oct 4, 2005, in forum: Access Table Design
    Replies:
    7
    Views:
    173
    tlyczko
    Oct 5, 2005
  8. roccogrand

    Membership Database Ideas

    roccogrand, Aug 9, 2006, in forum: Access Table Design
    Replies:
    1
    Views:
    102
    David Cox
    Aug 11, 2006
Loading...