COMBO BOX to CHECK MARK with multiple answers

[Guest]

I am converting a COMBO BOX to a CHECK MARK BOX for an alumni database. The
field that I am converting is called CONTACT TYPE and has a bunch of items
(ALUMNI, PARISHIONER, PARENT (CURRENT), PARENT (PAST), STAFF (CURRENT), STAFF
(PAST), CORPORATION, etc). I want to be able to select MULTIPLE answers.
For example, a contact could be an ALUMNI and PARENT (CURRENT). On the form
I want to be able to CHECK MARK more than one answer. Is this possible?

 

[Al Camp]

Smags,
Yes... but... your method/design is not "normalized", and doesn't take
advantage of the relational capabilities of the database.
I highly recommend you consider a table (and a subform) to hold multiple
Types against each Alumni. I think you'll go nuts trying to determine which
check boxes have been selected/have not been selected in subsequent queries,
forms, or reports.
(If chkAlumni..... If chkParishioner.....If chkParent.... and on and on
for all the possible types)

You gave 7 example Types with an "etc..." attached. What happens when
there are 15 Types... 18 Types? And it certainly appears as though a member
could easily have 3 or 4, or more Types associated to them.

Create a table to enter multiple Types against each alumni, linked to
your Alumni table via an Alumni key field.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions