Hi,

I need some help with creating a form that displays data from patient and doctors, where a patient can have more than one doctor and viceversa (m-n relationship). I created a subform that displays the data alright - a tabular form, I added a checkbox for each row in this tabular form so the user can select the patient-doctor information in that row for printing. The idea is similar to what you do in hotmail/yahoo, where you have a list of emails and next to each a box that you click if you want to delete selected rows.

So, when the user clicks on a row, the patientID and DoctorID should be added to another table - I'll use this auxiliary table ("SelectedPatients") to keep track of those rows that were selected so when I print the list it will only contain info about these patients. Also, I want to use this other table to keep track of checked boxes so I can display the 'tick' every time I upload the form.

Problems I have:
when I click on one box, all boxes for all rows in the form get checked.

I don't know how to bind the checkbox to something other than the query I use to bind the form to. If I try to bind the checkbox to something else than this query the form becomes 'read-only'.

How can I solve this???

Please any help very much appreciated! Ah, my knowledge of VB/Access is kind of basic.

Margarita