Relationships are different from related lists in that queries to the related tables are performed by the script.
Relationships can be configured via the Relationship (sys_related_list_script) table.
To set up a scripted related list, please complete the steps below:
Relationships form fields
Field | Description |
---|---|
Name | Relationship name displayed in the list. |
Apply to | Specify the table on the forms of which this related list will be displayed. |
Query from | Specify the table containing the source records for this list. |
Query with | In this field, you can put down a script specifying the records to include from the table processed by this relationship. |
In your scripts, you are free to use current and parent objects. The main purpose of this script is to generate a query that will be applied to the table specified in the Query from field.
In other words, the parent object is a record form specified in the Apply to field, and a current object is a list from a table specified in the Query from field. You can use any SimpleRecord Server-Side methods as directives in the current and parent objects, |