I have a table with a list of sites.
PK | Code | Discription | Active | rowguid | modifieddate
1|abc|site1|true
2|def|site2|False
3|ghi|site3|False
4|jkl|site4|False
5|lmn|site5|False
6|opq|site6|False
What I want to have happen is when one of the sites is modified to true. The current site that is set to true becomes false.
So let's say I change site 4 to be active (True) all other sites should be flagged as false as a result.
Thanks
John Fuhrman
PK | Code | Discription | Active | rowguid | modifieddate
1|abc|site1|true
2|def|site2|False
3|ghi|site3|False
4|jkl|site4|False
5|lmn|site5|False
6|opq|site6|False
What I want to have happen is when one of the sites is modified to true. The current site that is set to true becomes false.
So let's say I change site 4 to be active (True) all other sites should be flagged as false as a result.
Thanks
John Fuhrman