Access newbie needs a mentor

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

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

On Tue, 22 Sep 2009 18:00:01 -0700, Al Taylor
wrote:

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

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).

--

John W. Vinson [MVP]

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

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

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

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

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

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

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