A virtual field is not a column in a table and it is not used to store data: it is used to display data from another module.
For example, a record in the
In an attachment there is a reference column in the Primary module (the module from which the attachment is made) which stores the IRN of the attached record. This column is hidden from users. Data from the attached record does display in a virtual field (the virtual field points to the hidden reference field which points to the attached record in the Parties module).
In this example, the Loan Supervisor: (Loan Information) field is a virtual field called InfLoanSupervisor, and it points to a reference field called InfLoanSupervisorRef, which in turn points to the SummaryData field in an attached record in the Parties module.
When a search is made of a virtual field, two Also Searches may take place. In this Loans example:
- An Also Search Registry entry for InfLoanSupervisor can specify additional fields in the
Loansmodule to be searched.
- If there is an Also Search Registry entry for SummaryData in the Parties module (the column referenced by InfLoanSupervisor), a search of InfLoanSupervisor in the
Loansmodule will also search the Parties module columns listed in the Also Search Registry entry for SummaryData.