What do you call this?

[mrmims]

Hello,

What do you call/how would I go about do this:

I have a Cleaning Company database with a Table with 30+ check boxes with actions performed during a cleaning. At the end of the cleaning, not all 30+ check boxes are checked as not all actions are performed. When creating the report, how do I just show the check boxes checked, and the spacing will adjust based on which check boxes are checked?



If check box 1 is yes, but 2 - 10 are no, and 11 is yes. How, when I run the report, do I have have 1 and 11 stacked one ontop of the other like a nice organized outline? I don't want to see the unchecked boxes labels or the spaces where the labels would be.

Does this make sense?

Thank you for any and all help

[knarfreppep]

Don't have an infinite number of boolean fields in your table.

NORMALIZE!

tJobs { JobID, JobDescription }
tWorkDoneTypes { WorkDoneTypeID, WorkDoneTypeDescription }
tJobs_WorkDone { JobID, WorkDoneTypeID }

With this t structure what you want to do is easy.

[ranman256]

The way you built the table , yes.
instead, the 30 check boxes should be the tOptions table for you to pick from.
Use this list to ADD to the customer, what was performed. A parent-child table.
cust: ACME
counter
Refrigerator
sink

cust: ABC
sink

A child table , tCustCleaned, has ONLY the events that were performed. Not ALL.
these items were picked from the 30 available options.

[knarfreppep]

Parent = tJobs { JobID, JobDescription }
tOptions = tWorkDoneTypes { WorkDoneTypeID, WorkDoneTypeDescription }
Child = tJobs_WorkDone { JobID, WorkDoneTypeID }

[mrmims]

Thank y'all! I will do this now and let ya know it works