Firstly, apologies if this has been covered elsewhere -- I don't know what I should be searching for to solve my dilemma!
I am doing a maintenance manual, but part of this requires having 2 things:
1. A schedule matrix of what items need scheduling and whether they are done daily, monthly, yearly etc:
E.g. (3 columns - item, daily and monthly. Sorry -- the spaces I added to show the table didn't work so I added commas between columns)
Item, Daily , Monthly
1, Yes, Yes
2, No, Yes
3, Yes, Yes
2. A checklist of items for each time-period (i.e., 1 checklist for daily, 1 for monthly etc). (4 columns - daily, completed, by, comments)
E.g.,
Daily , Completed? , By: , Comments
Item 1 , Yes , Bob
Item 2 , Yes , Bob
Item 3 , No , Bob , Doesn't need replacing.
The problem is that the items identified in the matrix need to be taken and restructed for each checklist. I want the matrix and the checklist to be single-sourced because as soon as I update daily items on the matrix the checklist will be wrong, and vice versa.
Has anyone come across this problem before?
I'm stuck as to where to even look.. I have a few 'ideas' but none I'm sure would work.
Thanks,
Avril