Load where record not exists OR Delete where record exists.
I have an asset maintenance system that schedules services and maintenance tasks for pieces of mobile plant and cranes.
Services appear on the schedule predicted by the utilisation of the asset, and each service is calculated on multiples of 500 and can be made obsolete by a higher level. For example:
500hr Service
1000hr Service
2000hr Service
Until they trigger and the higher level makes the lower one(s) obsolete, they are all simultaneously planned in the predictive calendar. So my issue is, I have a table with the planned services and I want to ignore the ones that are made obsolete by an existing record.
Asset
Task
Replaced By
1
AVB1
PM106
PM108
2
AVB1
PM108
PM109
3
AVB1
PM109
4
AVB2
PM122
PM126
5
AVB2
PM126
PM128
6
AVB3
PM141
I’ve tried several options and to think of ways around it but can’t see the wood for the trees now that I’m so deep. I’m sure someone far more intelligent than myself will see the answer straight away or know of a simple solution.
