I have a table that has a column named “Status”. The value for that column may only be “Open” or “Closed”.
There should be no more that one record in an “Open” state.
How do I make it so that a user can only add a new record when all other records are in a “Closed” state?
Thanks in advance