The two options I have thought of is either to add a column boolean column called Current onto the table; but I'm sure that would violate some level of normalisation due to more than one record being able to be set as current.
Alternatively having another table that specifies the ID of the current record, but this also doesn't seem like a great way of doing it.
Is there a better way or convention for achieving this kind of thing?
Edit: I probably should of said there can only be one current record, so when it is changed the previously current record needs it's 'current' status removed. The system isn't complicated enough to need to worry about concurrency or anything like that. The main reason for the question is that I wanted to do things in the correct/conventional way if there was one.
I believe the best way is to have a settings table that will hold the ID of the current record.