>I have a form which must update a parent table as well as several child tables. I want to use a local view for this but I'm not sure how to add new records to a child table without affecting the parent table or the other child tables.
>
>Can anyone help me with this?
>
what is it exactly that you are trying to do?
is your problem that you don't have the key fields for the chields
then just add them to the view (just don't show them)

Arnon