For example, you may have a parent form which is a sales order, with a sub form containing the repeating order detail lines. Within the parent form, you may have a discount % field. You could then call the PARENT function to fetch the value of this field within the sub form and then use this within a calculation.
| Syntax | Where | Result |
|---|---|---|
| =PARENT(h) | h is a caption for an item on the parent form | A number |
The PARENT function allows formulae on sub forms to fetch values from the parent form.
| Example | Result |
|---|---|
| =PARENT('Discount') | Fetches the Discount field value from the parent form. |
