Editing a view

Using D6 and SQl Server. I have a many levelled
master-detail-detail-detail set of data I am trying to make the
editing easier for the lowest level. I created a view with
multiple joins that shows me exactly what I want. How should I
edit the data in the view? I have tried working on the
underlying tables, getting the correct keys, posting the table
record, closing the query and reopening but no luck.

Firstly, am I approaching this in the right way - I am used to
dbisam and paradox and perhaps I am not understanding the
limitations of ADO. Is there some way more simple to make the
view editable?

Not sure if you have enough information to answer or if this is
such a newbie question I will go down in flames. But 'publish
and be damned'.

Pat Bell

.