I have a view based on two tables ( A & B).

I allow updates to be sent to table A but not to table B.

When I insert a new record, it gets posted into table A.
Later when I do a REQUERY on the view, I get the following error message:

Cannot insert an empty row from a view into its base table(s).

How do I get around this problem?

Thanx in advance.