If I modify Master ID @ Row_Inserting()...
I have a Master-Detail table
If I modify Master Table Primary ID @ Row_Inserting() events ... like above..
Code ----------------------------------------------------------
function Row_Inserting($rsold, &$rsnew) {$rsnew["id"]= CurrentUserName()."_".$rsnew["id"];
return TRUE;
}
-----------------------------------------------------------------
will cus the "DETAIL Record" error while insert/update ...
--Error Message --------------------------------------------------------------------------------
The current user (19) is not authorized to insert the record. Master filter: id
='00002'
becuz the detail will be filtered by the "old ID" , how could I manual change the filter ID value to avoid the error ??