Templates are generally faster to use when creating variations of standard reports. This uses relationships to link queries within a query folder.

A system generated identity. It is blind to the user. It is also the primary key for the TmplRelation table.

Shows the identity of the detail table.
Example: Employee / Personal etc

Shows the identity of the detail attribute.
Example: EmployeeSysId / PersonalSysId etc

Shows the identity of the master table.
Example: ConfirmedEmp etc

Shows the identity of the master attribute.
Example: EmployeeSysId / PersonalSysId etc