I work for a large organisation, and I created a fairly straightforward database for recording some compliance activity in my division. It can report by each piece of compliance, and by individual teams in my division. It works pretty well and has gained me some praise. 
Anyway, the inevitable happened; someone higher up saw it and wants to expand it to work across the entire organisation, which is split up into directorates that have a few divisions within each one. They want it to report for each directorate and division as well as for individual teams.
It's a fairly simple database: there's a table holding each piece of compliance and information about it, and a second table where I create an entry for each piece of compliance an individual team has to follow. So I have a column for the team name, and all I really have to do is add another column for division and another for directorate, and add information to those columns, which is simple enough and I can do.
What want to know is, can anyone give me any tips on how to recreate the forms, queries etc. that I have already created, and modify them to filter by directorate and division, without having to trawl through every single one for every single team? I can see how to do what need to, I'm just wondering if there's a way of simplifying and streamlining all the duplication I will need to do. Any tips appreciated.
Anyway, the inevitable happened; someone higher up saw it and wants to expand it to work across the entire organisation, which is split up into directorates that have a few divisions within each one. They want it to report for each directorate and division as well as for individual teams.
It's a fairly simple database: there's a table holding each piece of compliance and information about it, and a second table where I create an entry for each piece of compliance an individual team has to follow. So I have a column for the team name, and all I really have to do is add another column for division and another for directorate, and add information to those columns, which is simple enough and I can do.
What want to know is, can anyone give me any tips on how to recreate the forms, queries etc. that I have already created, and modify them to filter by directorate and division, without having to trawl through every single one for every single team? I can see how to do what need to, I'm just wondering if there's a way of simplifying and streamlining all the duplication I will need to do. Any tips appreciated.
