Hi everyone,

I want to create an empty record, if there is no record in the base table. I use view. I got this error: Cannot insert an empty row from a view into its base table(s) (Error 1547)
While a view is updating, a new empty record (with no modified fields) is being inserted into one of the base tables of the view.

Make sure each record inserted from a view into a base table has at least one field that has been modified in the view prior to the view update.

On this code segment:

dodefault()
lnCustomerID=oJC.CustID
select CustomerInfo
requery()
if reccount()=0
   append blank 
   replace CustomerID with m.lnCustomerID
   set step on
   thisform.dotableupdate()
   requery()
endif
select RegionsInfo
requery()
if reccount()>0
   lnRegionID=RegionInfo.RegionID
   select TownsInfo
   requery()
endif          
set status bar on
set message to "Create a custom report configuration..."

How can I insert a blank record into the view?

Thanks in advance.