See where a form isused as a subform

From SMTX Wiki
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] <>