i posted this to Aspfree but this seems like a more appropriate place.



just wondering if anyone can explain why i can't do this with a datashape.



sSQL = "SHAPE {sp_getQuestions '" & qDate & "' } APPEND ({sp_GetAnswers} 

AS Answers RELATE qid TO qid)"



yet i can do this 



sSQL = "SHAPE {sp_getQuestions '" & qDate & "' APPEND ({Select 

qid,answerid,answer from tblQPA_AnswersT order by answerid} AS Answers 

RELATE qid TO qid)"



thanks

Christian