Robert,

> Hi Sean,
>
> So the question is, Even if this method were possible ( I shall have to
> look into updatable views ( I haven't heard of it before ) and
> temporary tables, is it a sensible way of User Interface updating databases?

"sensible" is something which each developer/application needs to consider.

Is there anything wrong with the approach? No.

Is there anything better? Perhaps, but they would be much more "complicated" -- think 5th normal form database design.


Sean