Allowing multiple choices from a drop down

[Guest]

I am using Access XP. I am trying to combine a church member ministry database. To do this, I've made individual tables for each ministry. Each table lists skills in that area of ministry (eg. Committee Ministry contains daycare, recreation etc. and People Ministry contains mentoring, outreach etc.). I've created a form to my Member table that includes a lookup to the other tables. Since many people have more than one skill in a given ministry, I need to design the form's drop down to accept multiple choices from within the one ministry. I would prefer to do this by using the control key. Any help is appreciated

Thanks

 

[Chris Nebinger]

Well, you need to step back and reevaluate your database
structure. You should not have a different table for each
ministry. Your tables should look like:

tblMinistries
MinistryID
Ministry

tblSkills
tblSkillID
MinsistryID
Skill

tblMembers
MemberID
MemberName
MemberAddress
etc.

tblMembersSkills
MemberID
SkillID


Now you can use a your member form and include a subform
to tlbMembersSkills.


Chris Nebinger

-----Original Message-----
I am using Access XP. I am trying to combine a church

member ministry database. To do this, I've made
individual tables for each ministry. Each table lists
skills in that area of ministry (eg. Committee Ministry
contains daycare, recreation etc. and People Ministry
contains mentoring, outreach etc.). I've created a form
to my Member table that includes a lookup to the other
tables. Since many people have more than one skill in a
given ministry, I need to design the form's drop down to
accept multiple choices from within the one ministry. I
would prefer to do this by using the control key. Any
help is appreciated.