Think about it, Rich. Haven't you noticed that when you change the structure of a base table and then go to modify a SELECT * view in the View Designer you get some nasty error message and all the fields are reset? Gotta be the same concept at work in this case.

>It was a SELECT * that created the view. I didn't think that this would cause an error with the update. But I've been bitten by field names of 'DESC'! OUCH!
>
>Renaming a lot of fields is a MAJOR pain. Nothing like breaking code everywhere!