Hi All,

I wanted to ask couple of questions regarding "Forms and List" module.

1, I have a two forms which is called "Stage 1" and "Stage2" and i wanted to join them using "Email" as a key. How would i do that?

2, I wanted to populate some data from "Stage1" form into "Stage2" form i.e Email, Name,et.. How do I do that.

3, Can we really join two forms on DNN "Forms and List" module?

Any help would be appreciated.

Thanks,
Yogs

Hi Sab,

You last post was very helpful. Tried below but with no luck.

 Any suggestions would be great.

SELECT  "Created at","Application ID","Enquirer name","Enquirer Email","Date of enquiry","How did you come to know about OCNLondon",
"Name of organisation","UKPRN (if applicable)","Website","Do you already deliver Accredited Qualifications",
"Organisation type","Created by","Changed by","Changed at"
 FROM

        ( SELECT FieldTitle,FieldValue
          FROM  UserDefinedFields F
          JOIN  UserDefinedData   D
          ON F.UserDefinedFieldId = D.UserDefinedFieldId
          WHERE ModuleId = 2042
          ) as S

          PIVOT (MAX(FieldValue)
          FOR FieldTitle IN ("Application ID","Enquirer name","Enquirer Email","Date of enquiry","How did you come to know about OCNLondon",
"Name of organisation","UKPRN (if applicable)","Website","Do you already deliver Accredited Qualifications",
"Organisation type","Created by","Created at","Changed by","Changed at")) as a


SELECT  "Created at","Application ID","Enquirer Name","Enquirer Email","Enquirer Role","Main Address Line","Address Line 2",
"Delivering OCN London qualification","Gaining OCN London accreditation for existing course(s)","
How many learners would you expect to register in twelve month period",
"Do you have funding in place to support delivery of the qualification",
"If Yes What is the source of your funding","Does your organisation have  (please select all that apply)",
"Do your tutors / assessors have qualifications in teaching & assessment",
"Do any assessors have qualifications / experience in internal verification","
DCELLS (Dept of Children / Education / Lifelong Learning and Skills)",
"ESTYN (Welsh Inspectorate)","CCEA (Council for the Curriculum / Examinations and Assessment)",
"Created by","Changed by","Changed at"
 FROM

        ( SELECT FieldTitle,FieldValue
          FROM  UserDefinedFields F
          JOIN  UserDefinedData   D
          ON F.UserDefinedFieldId = D.UserDefinedFieldId
          WHERE ModuleId = 2074
          ) as S

          PIVOT (MAX(FieldValue)
          FOR FieldTitle IN ("Application ID","Enquirer Name","Enquirer Email","Enquirer Role","Main Address Line","Address Line 2",
"Delivering OCN London qualification","Gaining OCN London accreditation for existing course(s)","
How many learners would you expect to register in twelve month period",
"Do you have funding in place to support delivery of the qualification",
"If Yes What is the source of your funding","Does your organisation have  (please select all that apply)",
"Do your tutors / assessors have qualifications in teaching & assessment",
"Do any assessors have qualifications / experience in internal verification","
DCELLS (Dept of Children / Education / Lifelong Learning and Skills)",
"ESTYN (Welsh Inspectorate)","CCEA (Council for the Curriculum / Examinations and Assessment)",
"Created by","Created at","Changed by","Changed at")) as b

Thanks,

Yogs
 

Hi Sab,

 I have join query "JOIN   On a.[Application ID]= b.[Application ID]"

 I want to join  on [Application ID] from both query "a" and "b".

Hope this make sense. Which will not work

Thanks,

Yogs