SELECT ID, Name, Title, PageType FROM SitePages WHERE PageType = 1 ORDER BY Title SELECT FormControl.FormName, SUBSTRING(FormInputControl.FieldName, 5, LEN(FormInputControl.FieldName)) AS FieldName, fm.FormID, FormInputControl.ID AS FieldID FROM FormControlMap AS fm INNER JOIN FormControl ON fm.FormID = FormControl.ID INNER JOIN FormInputControlMap ON FormControl.ID = FormInputControlMap.FormID INNER JOIN FormInputControl ON FormInputControlMap.FieldID = FormInputControl.ID WHERE fm.ClassConstant = 1

Parent Template:	#server.CommonSpot.UDF.tag.optionSetFromQuery(query=rstTemplates, valuesCol="ID", displayCol="Title")#
Select Form and Field:	#server.CommonSpot.UDF.tag.option(value="#rstFormFields.FormID#,#rstFormFields.FieldID#", display="[#rstFormFields.FormName#][#rstFormFields.FieldName#]")#
New Form Value:	#server.CommonSpot.UDF.tag.input(type="Text", name="txtValue")#
#server.CommonSpot.UDF.tag.input(type="hidden", name="txtDSN", value=strDSN)# #server.CommonSpot.UDF.tag.input(type="submit")#