Hi everybody,

Ok, I had an Approved (bit) field and I had a drop down (Awaiting Approval/Approved) + GridView. When I selected Awaiting Approval, I had checkboxes in my Grid, I could check multiple records, had a Save Approved person button what called SP. I also had ApprovedOn datetime field.

Now, suppose I'm switching to Status field (character 1) to have multiple statuses.

1. What kind of the interface would be good for the user?

2. Once the Person is Approved, the status can not change (since Approving a person creates records in other tables). I guess this should be coded as an Update trigger on the table level...

Thanks for ideas.