Creating a membership database
in [Tables]
|
Prev: multiple back-ends
Next: Relationship Layout
From: JD Steiger JD on 10 Feb 2010 20:50 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.
From: John W. Vinson on 10 Feb 2010 21:34 On Wed, 10 Feb 2010 17:50:01 -0800, JD Steiger <JD Steiger(a)discussions.microsoft.com> 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]
From: Steve on 11 Feb 2010 12:56 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 santus(a)penn.com "JD Steiger" <JD Steiger(a)discussions.microsoft.com> wrote in message news:BAFCF5BE-826A-45A4-ADC6-F07C334D54D1(a)microsoft.com... >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.
From: Stop$teve on 11 Feb 2010 13:12 "Steve" <notmyemail(a)address.com> schreef in bericht news:%23P9sLO0qKHA.1800(a)TK2MSFTNGP02.phx.gbl... > 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. 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's a shame !!) Arno R
From: John W. Vinson on 11 Feb 2010 13:58
On Thu, 11 Feb 2010 12:56:29 -0500, "Steve" <notmyemail(a)address.com> 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] |