Structuring question - many attributes per person in table

[Josh Kingcade]

I have 2 tables built in my database already: A People contact table
- tblPeople (with Primary Key pID); and an Involvement table -
tblInvolvement (with Primary Key InvID).

The Involvement Table includes one record for each possible area of
work in the church. I need a way to input multiple areas of service
per person - basically, to link one pID with multiple InvID, but not
in an exclusive manner.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create a form for the People table and a subform on that form for the
Involvement table. Make the Involvement data show in datasheet format.

Read the Access Help for info on subforms and how to make them.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQRwHsIechKq OuFEgEQKO7ACg+y OrGyXZI5FjX7RDI EudZefFTpgAoKNb
07CvvTCSr29x/YgdhdotdtSU
=1/Fg
-----END PGP SIGNATURE-----
Josh Kingcade wrote:

I have 2 tables built in my database already: A People contact table
- tblPeople (with Primary Key pID); and an Involvement table -
tblInvolvement (with Primary Key InvID).

The Involvement Table includes one record for each possible area of
work in the church. I need a way to input multiple areas of service
per person - basically, to link one pID with multiple InvID, but not
in an exclusive manner.

[PC Datasheet]

Josh,

How about a people involvement table that looks like:
TblPeopleInvolv ement
PInvID
PID
InvID
DateGotInvolved

Build a form/subform where the form is based on the people table and the subform
is baed on the involvement table. You can use the form wizard for this. Check
the LinkMaster and Linkchild properties - they should both be PID.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"Josh Kingcade" <jo**@cocsy.org > wrote in message
news:95******** *************** ***@posting.goo gle.com...

I have 2 tables built in my database already: A People contact table
- tblPeople (with Primary Key pID); and an Involvement table -
tblInvolvement (with Primary Key InvID).

The Involvement Table includes one record for each possible area of
work in the church. I need a way to input multiple areas of service
per person - basically, to link one pID with multiple InvID, but not
in an exclusive manner.

[PC Datasheet]

Make that -----

........and the subform is based on the PeopleInvolveme nt table..........

"PC Datasheet" <no****@nospam. spam> wrote in message
news:Bj******** ***********@new sread2.news.atl .earthlink.net. ..

Josh,

How about a people involvement table that looks like:
TblPeopleInvolv ement
PInvID
PID
InvID
DateGotInvolved

Build a form/subform where the form is based on the people table and the subform is baed on the involvement table. You can use the form wizard for this. Check
the LinkMaster and Linkchild properties - they should both be PID.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"Josh Kingcade" <jo**@cocsy.org > wrote in message
news:95******** *************** ***@posting.goo gle.com...

I have 2 tables built in my database already: A People contact table
- tblPeople (with Primary Key pID); and an Involvement table -
tblInvolvement (with Primary Key InvID).

The Involvement Table includes one record for each possible area of
work in the church. I need a way to input multiple areas of service
per person - basically, to link one pID with multiple InvID, but not
in an exclusive manner.