A Master Detail Map(MDMap) allows a field value in the Master table to be updated on the basis of a transaction in the Detail table. The properties of an MDMap are as follows :
|Name||Unique Name given to the MDMap.Cannot be altered.|
|Caption||The text that is displayed during run time. Can be altered.|
When this property is set to False ,Axpert searches for the record in the Master and if it exists, the specified Masterfield value is updated.If it doesn’t exist no operation is performed.
Set this property to True if you want the record from the Detail table to be added to the Master in case it does not exist there. In this case, the corresponding update definition should be specified in the MapText property.
|MasterTransaction||The TStruct into which the details are to be updated. Select from the list of TransId of the various Master Tstructs.|
|MasterField||The field in the Master TStruct which needs to be updated. On selection of the Master TStruct in the MasterTransaction property, all the fields in it are populated here for selection. During run time, this field in the Master gets updated in the manner specified in the UpdateType.|
|DetailField||This is the field in the Detail TStruct from which data is updated into Master field.|
|MasterSearchField||This is a field in the Master TStruct to which the detail relation field relates.The Master search field is the field to be searched for updation.All the fields in the Master TStruct selected in the MasterTransaction property are listed here for selection.In case Default is specified, the field search is done by the system where the key field or the Primary Key is used for matching.|
|DetailSearchField||This is a field in the Detail TStruct that relates it to the Master TStruct. All fields in the Detail TStruct are provided for selection.|
|MasterTable||On selecting the MasterTransaction,the table name corresponding to the Master TStruct is displayed here.|
|UpdateType||Select the Update Type from the list.
Add : Adds the value in the Detail field to the Master field
Less : Subtracts the value in the Detail from the Master field.
Highest: Replaces the highest value of the Detail field into the Master field.
Lowest : Replaces the lowest value of the Detail field into the Master field.
Inc : Increments by 1 the Master field value when a transaction is created and decrements when the transaction is removed/deleted.
Dec : Decrements by 1 the Master field value when a transaction is created and increments when the transaction is removed/deleted.
Replace : Replaces the Master field value with the latest value entered in the Detail field.In case data from Detail is replaced into a Master field and the detail transaction is deleted, then the already replaced data will be left as it is. In case the Init On Del property is set to True, then the master field is initialized to null when the detailed transaction is removed.
|ControlField||This property is used to perform Conditional update .Only those fields which accepts boolean values should be selected as ControlField. If the ControlField value is F ,then the master field is not updated.If the value is T, then the master field is updated.If the value in this field changes from T to F, then the update that was done earlier will be reversed.To set the ControlField property,
|Append||Set this property to True to update the records without using any search condition. If search field values are specified, records will be updated based on the search values.If search field values are not specified, records will get updated automatically without any search condition.|
|InitOnDel||Applicable when the UpdateType is Replace.This is the operation that should be initiated in the Master in case the Detail transaction gets deleted at any point of time.If the Init On Del property is set to True, then the master field is initialized to null when the detailed transaction is removed.|
|MapText||This property is applicable only when the Extended property is set to True.The update definition for the Master table is specified here.Read More|
|Onapprove||Set to True if the MDmap should post only when approved in the workflow.|
|Onreject||Set to true if the MDMap should post only when rejected in the workflow.|