Blowing up stuff, ice cream vans, and nudity. Transformers 3? JK, sounds fun. You'll probably get other opinions, but the first suggestion I can think of is a table of locations, and table with criteria. Create a dynamic value list based on the Criteria_table, use it for the checkbox set on a 'criteria' field in the location_table. Then you'll be able to go back and modify/search for locations based on the criteria.
Next step would be to create a table for Jobs, with it's own 'criteria' field, link it to the locations_table, and place a portal on the Jobs layout from the locations_table. Then, whatever criteria you select will show you the list of locations available.
Sounds like a plan. I'll give it a go. But how would I be to update the actual layout? Keep in mind that we may have several jobs going at the same time and I don't think it would be smart to duplicate and then modify layouts for every new job and criteria set.
Thanks so much for your input.
One layout for jobs, one record per job, and the 'criteria' field in the job table will link to the 'criteria' field in the locations table.