It keeps all the history, It changes fss.superceded to 1 when it adds another line, which has fss.superceded = 0.
So filter on fss.superceded=0, and you will only get the current status. (And you won't need the <>10 etc.
Cheers
Peter
It keeps all the history, It changes fss.superceded to 1 when it adds another line, which has fss.superceded = 0.
So filter on fss.superceded=0, and you will only get the current status. (And you won't need the <>10 etc.
Cheers
Peter
Cheers Peter.
That worked a treat