See where a form isused as a subform
Jump to navigation
Jump to search
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] <>