Subfrom from a JuctionTable with YesNo on the form.

I

Ivan Grozney

I have several subforms with check boxes on them. They contain anywhere from
15 to 57 items (it is what the customer wanted…). The customer wants to have
a report that will allow them to get all the records that have one of the
check boxes selected.

Of course the easy way to set up the system is for a table with a one to one
to the primary table and each of the check boxes to be listed.

I realize for the reports and record selecting is to have a have a tall
junction table. However I cannot figure out how to get all my items as check
boxes on the form the way the user wants them and still make a tall junction
type table.

I have

tblWCInjury tblWCContribFactor
WCInjuryID AUTONUMBER WCContribFactorID AUTONUMER
Name TEXT TagName Text
Address TEXT Tag Caption Text
… Current YesNo

Junction tblJWCi_WCc
WCiCCcID Autonumber
WCInjuryID Number
WCContribFactorID Number
Value YesNo

I cannot for the life of me get this thing to create a subform (link is
WCInjuryID) with check boxes on it with all the Contributing Factor Tags on
it.

Am I even on the right train? Or should I change continents, not just trains?

tia

Vanya
 
Top