I'm having problems getting a Shape Recordset to populate. Anyone have an
idea as to what the problem is with the following?

SHAPE {SELECT DISTINCT
div_id,
div_descr AS DIVISION
FROM AEO_CLS_DEP_DIV},
((SHAPE APPEND {SELECT DISTINCT
div_id,
dep_id,
dep_descr
FROM AEO_CLS_DEP_DIV},
((SHAPE APPEND {SELECT DISTINCT
dep_id,
cls_id,
cls_descr
FROM AEO_CLS_DEP_DIV})
RELATE dep_id TO dep_id) AS CLS)
RELATE div_id TO div_id) AS DEP

The error is occuring around position 75 "AEO_CLS_DEP_DIV}, ((SHAPE APPEND".
At its first occurance.