hi, I am using master / detail on A records and I would like that when I go to add the B records which are the details of the A record I would like some fields of B to auto-compile with the data of A without having to link all items with master / detail in common between A and B, many thanks in advance
You may want to review your table schema, in general you should avoid copy data from the master table to the detail table because of database normalization. You may get the data by a view joining the tables.If you must do that, it depends on which page you are working with, e.g. Master/Detail-Add of the master table or just Add page of the detail table. In both cases, you may use Row_Rendered server event to set the CurrentValue or EditValue of the field (depending on Edit Tag of the field), but in the latter case (i.e. Add page of the detail table), only the master record’s key field is known, you need to execute query to database to retrieve other data.