CREATE CURSOR crsGroups (grp_name C(10), email C(50)) INSERT INTO crsGroups VALUES ("GROUP1", "myemail1@company.net") INSERT INTO crsGroups VALUES ("GROUP1", "myemail1@company.net") INSERT INTO crsGroups VALUES ("GROUP2", "myemail3@company.net") INSERT INTO crsGroups VALUES ("GROUP3", "myemail4@company.net") INSERT INTO crsGroups VALUES ("GROUP3", "myemail1@company.net") CURSORTOXML(ALIAS(), "lcXml") *? lcXml XMLTOCURSOR(lcXml, "crsXml") BROWSE NOWAIT>I will check the referenced message. Thank you. But I decided to clarify my questoin as following:
>GRP_NAME EMAIL >--------------- -------- >GROUP1 myemail1@company.net >GROUP1 myemail1@company.net >GROUP2 myemail3@company.net >GROUP3 myemail4@company.net >GROUP3 myemail1@company.net >>
><MYLIST> > <GRP_NAME> > <NAME>GROUP1</NAME> > <EMAIL>myemail1@company.net</EMAIL> > <EMAIL>myemail2@company.net</EMAIL> > </GRP_NAME> > <GRP_NAME> > <NAME>GROUP2</NAME> > <EMAIL>myemail3@company.net</EMAIL> > <EMAIL>myemail4@company.net</EMAIL> > </GRP_NAME> ></MYLIST> >