If I modify Master ID @ Row_Inserting()...

[netenken1]

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

[Webmaster]

You can consider update the key values in Row_Inserted server event to avoid the error.

[netenken1]

so, you means the master-detail update behavior is "MASTER" table "inserted/updated" and then trigger "DETAIL" table events

[Webmaster]

No, just use the master table Row_Inserted/Row_Updated server event. Perform SQL updates to update all the key values in the master/detail tables.