-----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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQRwHsIechKqOuFEgEQKO7ACg+yOrGyXZI5FjX7RDIEudZe fFTpgAoKNb
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.