Opinions wanted re:how to go about laying out something

[Dennis Snelgrove]

I've got a database where we need to run the same report for a number
of different locations, and these locations need to be run on
different days. I'm setting up a report scheduling system where the
user will be able to create a new report instance, choose what
locations are included in this instance, and then choose which day(s)
it should run. What I'm trying to decide is whether it would be better
to use a subform to choose the days to run the report instance, or to
put seven checkboxes on the form and have the user check off the days
needed. Using a subform would allow me to do most of my work through
SQL and is the more "normal" way to do this, but using the checkboxes
would be a lot more intuitive and a lot cleaner.

What do you all think?

 

[Allen Browne]

Use a subform, bound to a table with 2 fields like this:
LocationID relates to your table of locations
DayOfWeek Number (1 to 7)
The combination of the 2 fields can be primary key (which ensures no
duplicates.)