>>CREATE CURSOR MyTable (transitNo C(10), region C(2)) >>INSERT INTO MyTable VALUES('00001','NY') >>INSERT INTO MyTable VALUES('00001','CA') >>INSERT INTO MyTable VALUES('00001','FL') >>INSERT INTO MyTable VALUES('00001','CO') >> >>INSERT INTO MyTable VALUES('00002','CA') >>INSERT INTO MyTable VALUES('00002','NY') >>INSERT INTO MyTable VALUES('00002','WA') && I changed this just for testing >>INSERT INTO MyTable VALUES('00002','CO') >> >>SELECT DISTINCT region FROM MyTable INTO CURSOR crsDistReg >>lcSelect = [SELECT TransitNo] >>SELECT crsDistReg >>SCAN >> lcSelect = lcSelect + [, MAX(IIF(Region = ']+Region+[','Yes','No ')) AS ]+Region >>ENDSCAN >>lcSelect = lcSelect +; >> [ FROM MyTable GROUP BY TransitNo INTO CURSOR crsXTab] >>&lcSelect >>BROWSE NORMAL >>>