"Geo" <no@spam.com> wrote in message
news:%23a$bkOFUHHA.1200@TK2MSFTNGP02.phx.gbl...
> Hi folks, I have two tables CurrentNews and HistoricNews when a news item
> is created it is inserted into CurrentNews it is assigned a storyID
> (ST071) which it maintains through its life cycle. The story then gets
> reviewed and the reviewed column is set to true it is also given a version
> number.
>
>
>
> If a user edits an item the version in CurrentNews is removed and inserted
> in to HistoricNews the updated version is inserted into the currentnews
> and the version number is updated and the reviewed state is set to false
> until it is reviewed again.
>
>
>
> The problem I have is that if an item is edited then I would like to
> display the previous version from the HistoricNews table until the newer
> version has reviewed state has been flagged as true.
>
> Any thoughts?
>
> Thanks in advance
>
> Geo
>
>
>
>