>>Hi Fred
>>
>>I take it that the view(2) will always be a complete clone of view(1).
>>By that I mean whatever changes I make to records in view(1) will always be imediately impacted on view(2).
>
>Caution here. View(2) may NOT be an exact clone of view(1) as it may contain more up-to-date data than view(1). Really depends on how often the backend data is being updated.
>

That does become a real problem because of course the whole point of my doing this is so the I can do calculations on uncommited records. In fact the views end up differing widly straight away because there is no link between them other than the shared underlying table.

Oh well back to the drawingboard:(