H
Heather Vernon
I'm trying to build a form that pulls info from 3 tables joined together to
allow users to select specific records from tblAnimalInfo, but is still
editable!
More specifically: I want to have checkboxes on the form that will select
certain animalIDs in a multi-form multi-user setup. I can do the multi-user
setup by creating a local table (tblSel). I can do the multi-form setup by
adding formID to tblSel. Checkboxes can be linked to yes/no fields, but as
soon as I add a third table to my form source, they can't be edited. If I do
a subform, I can't get the animalID's to list continuously because the
subforms would be linked with the animalID's; this would make the form a pain
to use.
So after all of that: how can I get this to work?
I do have a temporary solution using a code module that interacts with my
tblSel to mark the checkboxes, BUT IT IS SOOO SLOW.
The three tables are described below, and here's their relationship:
tblSel INNER JOIN (tblAnimalInfo INNER JOIN tblAnimalTreatment ON
tblAnimalInfo.AnimalID = tblAnimalTreatment.AnimalID) ON tblSel.AnimalID =
tblAnimalInfo.AnimalID. Pretty basic.
(FYI: tblAnimalTreatment is the middle table of a many-to-many relationship
that I can't get rid of)
tblSel
--
formID
animalID
selected (yes/no)
tblAnimalInfo
--
animalID
status
studyID
tagID
tblAnimalTreatment
allow users to select specific records from tblAnimalInfo, but is still
editable!
More specifically: I want to have checkboxes on the form that will select
certain animalIDs in a multi-form multi-user setup. I can do the multi-user
setup by creating a local table (tblSel). I can do the multi-form setup by
adding formID to tblSel. Checkboxes can be linked to yes/no fields, but as
soon as I add a third table to my form source, they can't be edited. If I do
a subform, I can't get the animalID's to list continuously because the
subforms would be linked with the animalID's; this would make the form a pain
to use.
So after all of that: how can I get this to work?
I do have a temporary solution using a code module that interacts with my
tblSel to mark the checkboxes, BUT IT IS SOOO SLOW.
The three tables are described below, and here's their relationship:
tblSel INNER JOIN (tblAnimalInfo INNER JOIN tblAnimalTreatment ON
tblAnimalInfo.AnimalID = tblAnimalTreatment.AnimalID) ON tblSel.AnimalID =
tblAnimalInfo.AnimalID. Pretty basic.
(FYI: tblAnimalTreatment is the middle table of a many-to-many relationship
that I can't get rid of)
tblSel
--
formID
animalID
selected (yes/no)
tblAnimalInfo
--
animalID
status
studyID
tagID
tblAnimalTreatment