I have a child table that has as its primary key and autoinc field.
I have a one-to-many field for linking to the parent.
I want to use the child table's key as the key field to update the child table on.
i.e. Update the view via sql update replacing key fields and modified ones.

I use the view.
I then append a blank record.
I then issue a tableupdate(.t.,.t.) (forcing for testing purposes)
I look at the underlying child table from which the view was built and i see the changes

Now here's the problem.
I leave foxpro and return to it. I then go to the child table, browse it, and the records are no longer in it.

What's going on?
How do I fix this?
What have I forgot to do?

TIA,
Mike