Hey,
I would like a view to insert a key value and update the views
modified field (which is .null.).

The view I have is composed of 2 free tables.

FROM Table_A LEFT OUTER JOIN Table_B ;
ON Table_A.KeyValue = Table_B.KeyValue

The view has "Send SQL Updates" checked, key fields marked for Table_A and Table _B, "SQL UPDATE" is checked as well as "Key and modified fields".

Some of the records retrieve .Null. values for table_b,
since there are no matching records in table_b to table_a.
If I edit the .Null. value in the view and move the record
pointer I get an error "Update Conflict".
Is is possible to get the View to update by inserting
the keyvalue into table_b and then updating the modified field?

I searched the thread through and through.. but can't find a solution...
thanks,
Daniel