I&#039;m using the following SHAPE command:<BR><BR>SHAPE {SELECT * FROM Chapters WHERE SchoolID=320}<BR>APPEND ({SELECT * FROM ChapterLink}<BR>RELATE ID TO ChapterID) AS Advisors<BR>({SELECT FirstName, LastName FROM LocalAdvisors }<BR>RELATE UserName TO UserName) AS AdvName<BR><BR>I get an error, "Column (UserName) does not exist in the appropriate rowset", which is correct, the UserName column actually exists in the ChapterLink table. But, I can&#039;t figure out how to construct this SHAPE command so that it works like that. Could someone please help me out here? I&#039;m new to the Shape Command.<BR>Thanks--Jesse