L
LeAnn P via AccessMonster.com
Hello,
I'm not sure if I have structured my tables correctly but here is what I have and what I want to do. I have patient info table and a antibody list table. The antibody list table is a list of possible antibodies using an autonumber identifier and antibody text field. Patients can have multiple antibodies so I have a junction table with PatID and AntibodyID fields.
I have a main form for patient info. I want to click a button to open another form (I assume an unbound form) with all the possible anitbodies as checkboxes. After user clicks all relevent antibodies, click save. I want to insert records into the junction table based on what the user checked. (I will then display in a list box on the main form the patient's antibodies).
Can anyone make sense of what I'm looking for and help me?
Thanks!!
I'm not sure if I have structured my tables correctly but here is what I have and what I want to do. I have patient info table and a antibody list table. The antibody list table is a list of possible antibodies using an autonumber identifier and antibody text field. Patients can have multiple antibodies so I have a junction table with PatID and AntibodyID fields.
I have a main form for patient info. I want to click a button to open another form (I assume an unbound form) with all the possible anitbodies as checkboxes. After user clicks all relevent antibodies, click save. I want to insert records into the junction table based on what the user checked. (I will then display in a list box on the main form the patient's antibodies).
Can anyone make sense of what I'm looking for and help me?
Thanks!!