I'm looking for suggestions on how to do this.
We have a fleet of aircraft that have mixed variants (ie some have cargo doors, others do not). I am looking to control the workcards that are issued for the maintenance. Currently we have them stored on Word. For simplicity, a particular maintenance check that may have 200 different workcards are stored as a single Word file. Each workcard will have a series of unique operations and associated signature block. Because of the different variants, not all of the workcards are applicable. This means that say 30 out of the 200 are not required. I am trying to print out only what I need.
I can create a database and query that will allow me to define what workcards are are required for a particular aircraft and particular maintenance check without much problem, but I am unsure on how to tie the actual workcard to the requirements.
Obviously it would be ideal for the workcards to be printed as a report but the workcards need to be in a standard format. For the workcard operations, Access would only print out what was required (a workcard could have one operation or three or four) and that would leave me with blank space on the report which is un-acceptable. I must have the workcard formatted in the example attached (which has empty operations - not the same as blank space). I hope I have managed to get across what I mean.
If anyone has any suggestions I would be very grateful.
We have a fleet of aircraft that have mixed variants (ie some have cargo doors, others do not). I am looking to control the workcards that are issued for the maintenance. Currently we have them stored on Word. For simplicity, a particular maintenance check that may have 200 different workcards are stored as a single Word file. Each workcard will have a series of unique operations and associated signature block. Because of the different variants, not all of the workcards are applicable. This means that say 30 out of the 200 are not required. I am trying to print out only what I need.
I can create a database and query that will allow me to define what workcards are are required for a particular aircraft and particular maintenance check without much problem, but I am unsure on how to tie the actual workcard to the requirements.
Obviously it would be ideal for the workcards to be printed as a report but the workcards need to be in a standard format. For the workcard operations, Access would only print out what was required (a workcard could have one operation or three or four) and that would leave me with blank space on the report which is un-acceptable. I must have the workcard formatted in the example attached (which has empty operations - not the same as blank space). I hope I have managed to get across what I mean.
If anyone has any suggestions I would be very grateful.