Checkboxes in forms for acupuncture

I've been asked to help automate a Traditional Chinese Medicine
practice. Parts of it are going to be very like Northwind, with a
tblPatients, a tblTreatmentSessions (similar to Orders), a
tblTreatmentDetails, and a tblNeedlings (like Products).

In acupuncture there are apparently lots of specific body points into
which the practitioner inserts his needles, all of which will be listed
in tblNeedlings. In each treatment session the acupuncturist will use
some of these points, and we want to record which points are used in
each session.

I want to do this by listing all possible needle points on a session
form (which will obviously also include the date of the session, the
patient number and so on) and have the acupuncturist check the box for
each needle point used during the session. This will be recorded in
tblTreatmentDetails. (I'll probably drop these checkboxes all over an
acupuncture schematic of the human body, but that's just cosmetic).

How do I go about taking the NeedlePointID field from tblNeedlings,
associating it with a particular checkbox on my form, and thus recording
in tblTreatmentDetails that these particular points were used in that
session?

Steve

One way to handle this is if there will be a fixed number of these points,
make them Yes/No fields in tblTreatmentDetails instead of having a separate
table listing them. Then you could just bind each checkbox to its associated
Yes/No field.

--
Wayne Morgan
Microsoft Access MVP


"Stephen Glynn" wrote in message
...
I've been asked to help automate a Traditional Chinese Medicine
practice. Parts of it are going to be very like Northwind, with a
tblPatients, a tblTreatmentSessions (similar to Orders), a
tblTreatmentDetails, and a tblNeedlings (like Products).

In acupuncture there are apparently lots of specific body points into
which the practitioner inserts his needles, all of which will be listed
in tblNeedlings. In each treatment session the acupuncturist will use
some of these points, and we want to record which points are used in
each session.

I want to do this by listing all possible needle points on a session
form (which will obviously also include the date of the session, the
patient number and so on) and have the acupuncturist check the box for
each needle point used during the session. This will be recorded in
tblTreatmentDetails. (I'll probably drop these checkboxes all over an
acupuncture schematic of the human body, but that's just cosmetic).

How do I go about taking the NeedlePointID field from tblNeedlings,
associating it with a particular checkbox on my form, and thus recording
in tblTreatmentDetails that these particular points were used in that
session?

Steve

Wayne Morgan wrote:
One way to handle this is if there will be a fixed number of these points,
make them Yes/No fields in tblTreatmentDetails instead of having a separate
table listing them. Then you could just bind each checkbox to its associated
Yes/No field.

Thanks. That would probably simplify life a lot. I'll give it a shot.

Steve