Thanks Nancy...

It's true, new techniques and deadlines don't mix, but you couldn't pay me enough to do something else for a living! I love this stuff.

And fortunately, there's always the UT when I need to get a quick answer on something!

Larry

>PMFJI, perhaps I am overreacting to the quoted statement, but you do not have to set a field in a view in order to set THAT SAME field to updateable. But yes, as Nick said, you do have to have _a_ key field for the table that you are updating fields in. The reason, as it's been explained to me, is how does the view know which record to update if it doesn't know what its key field is.
>
>HTH
>
>p.s. my sympathies to for working on views AND a deadline :-)
>
>...
>>>>But I can't make the other fields updateable UNLESS I make them keyfields as well... Am I missing something here?
>>>
>>>You have fields from 2 tables in your view, so if you want to be able to update them all, you should set 2 key fields (tstParent.prntid and tstChild.prntid), then you can make any of view fields updatable, with the condition that "All Tables" in "Tables" combobox on "Update Criteria" tab is selected.
>>
>>Ok, this is definitely something I've got to get a handle on, but in the meantime, I've got a project to finish and I'm going to have to stick to what I know for now.
>>
>>Thanks for your help
>>
>>Larry