Find the Objects
By dragging and dropping, a user populates the right side of the window with the property sheet fields from the selected object type.
The following query finds all the objects in the database of the selected object type once user clicks on the Create Form button. Here [MODULE] is a variable and the value depends on the object type.
SELECT name, pdm_blobid
FROM [MODULE]
WHERE pdm_current = 1 AND
pdm_blobid = (SELECT DISTINCT child FROM parent_list);
The user can either Save the form or execute the query. Save displays a Save As window—see the example below.
Example:
Query Save As