Access newbie needs a mentor

No problem! I've still have those DUH! moments...

--
Gina Whipp

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

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

"Al Taylor" wrote in message
...
DUH!!! I should have known that... Foreign Key. Thanks for clearing that
up.

Al

"Gina Whipp" wrote:

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

"Al Taylor" wrote in message
...
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

"Gina Whipp" wrote:

Thank you (just giving back) and you're welcome... Come back if you
have
any problems!

--
Gina Whipp

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

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

"Al Taylor" wrote in message
...
Thank you Gina,

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

Al

"Gina Whipp" wrote:

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

"Al Taylor" wrote in message
...
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


"Gina Whipp" wrote:

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/acc...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

"Al Taylor" wrote in
message
...
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