Show data from a master table on the details View/Edit/Add pages.
To add this event, insert C#/VB.NET code snippet on the Page Designer screen:
dynamic data;
MVCFunctions.Echo("Master Info<br>");
if(XVar.Pack(data = XVar.Clone(GlobalVars.pageObject.getMasterRecord())))
{
MVCFunctions.Echo(MVCFunctions.Concat("Field1: ",data["Field1"],"<br>"));
MVCFunctions.Echo(MVCFunctions.Concat("Field1: ",data["Field2"],"<br>"));
}
For example, "Orders" is a master table and "Order details" is a details table.
dynamic data;
MVCFunctions.Echo("Order Info<br>");
if(XVar.Pack(data = XVar.Clone(GlobalVars.pageObject.getMasterRecord())))
{
MVCFunctions.Echo(MVCFunctions.Concat("Field1: ",data["CustomerID"],"<br>"));
MVCFunctions.Echo(MVCFunctions.Concat("Field1: ",data["EmployeeID"],"<br>"));
}
See also: