Configuring New Data into an Old Report

[Carrinmere]

So I have a Table that lists all the different types of training required by my employees and the frequency with which they have to do the training. With that table I have created a query designed to display specific training for certain requirements. With that query I have generated a report for that data to be displayed with cells color coded based on whether or not someone is overdue the required training. Additionally I have created a Form designed to update my Training Table with new data such as a new training requirement that comes out that was not required previously. An example would be a Sexual Harassment course or OSHA safety course. Is there a way on my report to plan for future cells to be added and configured without having to crack open the innards of the database every time a new training requirement comes out?



Carrinmere

[Micron]

Is there a way on my report to plan for future cells to be added and configured without having to crack open the innards of the database every time a new training requirement comes out?

That sounds like you've created something in a spreadsheet fashion. If you have a table field for every type of training then that is wrong and would be why you're asking that question.

One design scenario would be where a report section header would be my name, followed by every type of training I require. New training for me is just another row item. If a new one comes along that no one required up to that point, then that new training requirement would be a record (row/list item) in a table of training types/requirements, not a new field. So what have you done design-wise?