Radio button list

[EKoster]

I want to be able to change a record to a next status. The record from the table [data] only stores the id field information to [status] on data.status_id = status.status_id.

I need the radio buttons to display all entries (except one) where data.status_id <> status.status_id

How can I do this? Also I'm going to attach a script to this control, for on some status a mail needs to be sent too. This must be a temporary field for my records must be left read-only. So a sql statement script will do the actual updating.