Access newbie needs a mentor

A

Al Taylor

Hello all,

I am making this post because I am completely new to access and I have been
charged with creating a database for my church. This database is to contain
church members and emergency contacts for the members.

I have so far created two tables. A members table and an emergency contacts
table. I see this as a one to many relationship because one church member may
have maybe two or three people to contact in case of emergency (i.e. If I
fall ill during a church function, the first person I want you to call is my
mother, if she is not avalible then call my brother).

I have also created a form but cannot seem todisplay and malipulate data on
both tables at the same time.

The bottom line is that I am asking for someone to be a mentor for me, to
becoma a 'Master Yoda' for me. Please.

Signed Al Taylor
 
G

Gina Whipp

Al,

As much as we would LIKE to be one-on-one with you how would that be fair to
all the others requesting help? This is a volunteer newsgroup and by
volunteer I mean... no pay and OUR volunteer time. So, let's move past
that...

In order for us TO help you please provide the fields in the tables you do
have. It does sound like you need a form/subform set-up but not sure how to
tell you to set that up without knowing what fields are in your tables.
Also, here are some tutorials that might help...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

John W. Vinson

Hello all,

I am making this post because I am completely new to access and I have been
charged with creating a database for my church. This database is to contain
church members and emergency contacts for the members.

I have so far created two tables. A members table and an emergency contacts
table. I see this as a one to many relationship because one church member may
have maybe two or three people to contact in case of emergency (i.e. If I
fall ill during a church function, the first person I want you to call is my
mother, if she is not avalible then call my brother).

I have also created a form but cannot seem todisplay and malipulate data on
both tables at the same time.

The bottom line is that I am asking for someone to be a mentor for me, to
becoma a 'Master Yoda' for me. Please.

Signed Al Taylor
Click to expand...

You might be able to adapt my church membership database. Drop me an email at
jvinson <at> wysard of info <dot> com (edit out the blanks and fix the
punctuation) and I'll be glad to send you a copy free of charge. It classifies
members within families, and you could certainly use a family member as an
emergency contact, or if you want more flexibility, add a new table and a form
or two; I'd be happy to work with you *as time is available* (I'm self
employed and have paying work to do).
 
A

Al Taylor

Thank you Gina,
Thanks for the URL's you included in your reply, I think they will help
greatly.
I do understand that.

This is the Member Table:
ID AutoNumber (Primary Key)
Suffix Text
Fname Text
Lname Text
Street Address Text
Apt Number Text
City Text
ZipCode Text
HomePhoneNumber Text
CellPhoneNumber Text
EmailAddress Text

This is the emergency contact Table:

ID AutoNumber (Primary Key)
Emr1Fname Text
Emr1Lname Text
Emr1Hnum Text
Emr1Cnum Text
Emr2Fname Text
Emr2Lname Text
Emr2Hnum Text
Emr2Cnum Text
 
G

Gina Whipp

Al,

Okay, I see the reason you are having an issue linking the two tables...
They are not *related* in any way, so let's fix that.

This is the Member Table:

tblMembers
mMemberID AutoNumber (Primary Key)
mSuffix Text
mFname Text
mLname Text
mStreet Address Text
mAptNumber Text
mCity Text
mZipCode Text
mHomePhoneNumber Text
mCellPhoneNumber Text
mEmailAddress Text

This is the emergency contact Table:

tblEmergencyContacts
ecEmergencyContactID AutoNumber (Primary Key)
ecMemberID (FK-Number) <-----Add this field and relate to tblMember (Go to
Tools-Relationships)
ecEmrFname Text
ecEmrLname Text
ecEmrHnum Text
ecEmrCnum Text

I made a few changes to your tables:

1. Removed all spaces from field names. Just make for more work when having
to do code.
2. In tblEmergencyContacts you only need on field per contact not Emr1Fname
and Emr2Fname. As each record will contain a name going down not across.
So now when you make the relationship you will have one to many and each
Member can have as many emergency contacts as you like.
3. You may want to include WorkNumber because some folks work Sundays.

Your main form will have a RecordSource of tblMembers and format to single
form view and the subform will have a RecordSource of tblEmergencyContacts
and format to continuous form view. Once you do that you should be able to
*alter* data in both forms.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
A

Al Taylor

Thank you Gina,

You have gone above and beyond the call, I will try what you suggest and let
you know the result.

Al
 
A

Al Taylor

Gina,

What is the purpose of this field? I think I understand the relationship
piece of this but why the ecMemberID field and what is FK-Number?

ecMemberID (FK-Number) <-----Add this field and relate to tblMember (Go to
Tools-Relationships)
Al
 
G

Gina Whipp

Al,

The purpose of that field is to set up a relationship to the
tblEmergencyContact table which you are going to need in order to enter
emergency contacts FOR members. FK = Foreign Key and because it is going to
relate (link) to mMemberID which is an Autonumber you need it to be a
Number. You can't relate a Text field to a Number field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unsure of what it is called... 1
Photo Directory Template 14
Church Directory 3
Access Newbie asks for help. 9
Is Access right for what I want to do? 4
Browse button for access form 1
Many to many table realtionship 1
Simple Access Project - Almost There Just Need Some Help... 2

Top