Hi
I have been asked to create 2 documents -
1) A Vacation Schedule for the Trainers and
2) A Master Training Calendar of where, what and who will be conducting
Training

The challenge I am facing is creating a link with these two documents which
will allow simultaneous update to the Training Calendar about the status of
the trainer (ie if they are on vacation).

Can anyone offer any suggestion on how I can approach or solve this challenge?