D
Dave
Sorry about this repost but I don't think I explained myself very
well.
I have these tables; tblPtAntibodies (linked to patient),
tblAntibodies (120 records. List of all possible antibodies to choose
from) these two tables are many-to-many, hence a third, junction table
to connect them, tblAbJunction.
I would like to have a PtAntibody form with Antibody subform
(Continuous) with a checkbox next to each antibody record. The user
clicks one or several antibodies and these selected items become part
of the record of the one patient. eg User selects one row, one row is
added to the record. Select 10 rows, 10 new rows are added to the
record.
I know this can be done, but I seem to have a mental block on this
one. Google searches have been fruitless, or I'm asking the wrong
questions.
Thanks everyone,
Dave
well.
I have these tables; tblPtAntibodies (linked to patient),
tblAntibodies (120 records. List of all possible antibodies to choose
from) these two tables are many-to-many, hence a third, junction table
to connect them, tblAbJunction.
I would like to have a PtAntibody form with Antibody subform
(Continuous) with a checkbox next to each antibody record. The user
clicks one or several antibodies and these selected items become part
of the record of the one patient. eg User selects one row, one row is
added to the record. Select 10 rows, 10 new rows are added to the
record.
I know this can be done, but I seem to have a mental block on this
one. Google searches have been fruitless, or I'm asking the wrong
questions.
Thanks everyone,
Dave