A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating a membership database



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old February 11th, 2010, 01:50 AM posted to microsoft.public.access.tablesdbdesign
JD Steiger
external usenet poster
 
Posts: 1
Default 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 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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.