trying to create a report of sorts (its more like a "check-the-box form" (for data entry); and I'm at a complete loss on how best to set it up / how to start. Any direction (and that's really all I "ought" to need) will be greatly appreciated in advance.
tables
tblMfrRep - manufacturer's representatives and their contact info
tblMfrRep_Mfrs - list of multiple manufacturers that are represented by a single MfrRep
tblMfr - details about the individual manufacturers
tblCategories - category "tags" that could be applied to any of the manufacturers (where it is possible/likely that any one manufacturer would have multiple categories tagged to it)
tblMfrCategory - table with a record for each category a manufacturer has been tagged for. EX: record (1) - mfr_1, cat_1; (2) mfr_1, cat_2; (3) mfr_1, cat_4; (4) mfr_2, cat_1: (5) mfr_2, cat_3; <etc.>
what I simply (or not simply) am trying to do is issue a "check off the box" form to each rep that includes (trust me on this.... the scale of the project and skill sets are not so grand that this does make sense)....
- the Rep Agency Name
- each of the Manufacturers they represent
- and then UNDER EACH INDIVIDUAL MANUFACTURER
- a list of ALL of the possible categories, with some sort of annotation indicating which of those categories have already been entered in tblMfrCategory
with this they will be able to check off which have been missed and still need to be added, which are no longer correct and should be removed, and (of course) which they concur with and can remain as entered.
*** it is this last task that has me dumbfounded, and that i need direction on (plz.)
this will be a PAPER report/form, that "someone" will review BY HAND; there definitely will be no digital form with a combobox of categories to select from (tried that... not the right approach; to tedious; required too much effort; blah blah blah....) What I've convinced myself will work is and old fashioned... "can fill it out while on the subway home approach"; and any more than that will die.
with much thanks in advance
mark