See where a form isused as a subform: Difference between revisions
Jump to navigation
Jump to search
Created page with "If you want to know if a form is used as a subform, do this :" |
No edit summary |
||
| Line 1: | Line 1: | ||
If you want to know if a form is used as a subform, do this : | If you want to know if a form is used as a subform, do this : | ||
This query tells you the formfields where the form with internal label "form_internal_name" is mapped. | |||
SELECT * FROM [FormField] WHERE [DynamicSubForm] = 'form_internal_name' | |||
This query returns the first 10 fields that sets something using synmicsubform (fixed or via placeholders) | |||
SELECT TOP 10 * FROM [FormField] WHERE [DynamicSubForm] is not null and [DynamicSubForm] <> '' | |||
Latest revision as of 09:10, 4 August 2022
If you want to know if a form is used as a subform, do this :
This query tells you the formfields where the form with internal label "form_internal_name" is mapped.
SELECT * FROM [FormField] WHERE [DynamicSubForm] = 'form_internal_name'
This query returns the first 10 fields that sets something using synmicsubform (fixed or via placeholders) SELECT TOP 10 * FROM [FormField] WHERE [DynamicSubForm] is not null and [DynamicSubForm] <>