>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.

Asif: Does the new record have an ID field that is not being filled in? This could violate a trigger situation. Are you sure the record is really being posted to Table A? It sounds like the posting isn't being done until you do the REQUERY(), and then the error pops up. Check actual field values in the View, Table A and Table B. This might give you some clues.

Barbara