GRID: Append record in view, but cannot TABLEUPDATE()

[bbq]

I can edit the record in remote view and TABLEUPDATE() sucessfully.
However , when I try to append a record in remote view, and run TABLEUPDATE(), the system said "Field XXX does not accept null values". I am sure that I have entered the value. Why?

Thanks.

 

[fluteplr]

Are you sure that field is updateable in the view? Check the update tab in the view builder.

 

[danceman]

how are you adding the record?

insert into?
append blank?

are there any table rules? Attitude is Everything

 

[Guest_imported]

I can update the existing records and TABLEUPDATE() sucessfully. But when I append record and run
TABLEUPDATE(), it said "Field XXX does not accept null values"
I use "Append Blank" and "Replace...with..."
Help me....pls.

 

[Guest_imported]

I can update the existing records and TABLEUPDATE() sucessfully. But when I append record and run
TABLEUPDATE(), it said "Field XXX does not accept null values"
I use "Append Blank" and "Replace...with..."
Help me....pls.