Update Grid Search Results

[scotthanes]

What is the esiest way to update the one feld (column) in a grid with the same value for every row.

For example: I have a grid with Patients and the assigned Doctor. I want to pull up a group of patients in a grid and reassign the doctor....without having to selct a drop down next to each patient and assign the same doctor down the line.

I was thinking a lookup or drop down list...but this is redundant...considering the same field in every row will be changed to the same value. And this value will be determined by the user.

If there is a way to pull the grid results into a dialog I could easily write the code. But I'm stumped on this one.