Data Shaping / Hierarchical recordsets

[hdougl1]

Using for the first time MSDataShape provider I'm getting an error on the rs.open statement on my asp page;
MSDataShape error '80040e14'
Column (Machine_StoreId) does not exist in the appropriate rowset

Here's the connection object stuff;
Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.Provider = "MSDataShape"
%><!-- #include file=&quot;dbconn.Inc&quot; --><%

Here's my SQL statement;
SHAPE {SELECT Store_ID, Store_Address1, Store_Address2, Store_City, Store_State, Store_Zip FROM RDC_Store_Info} APPEND({SELECT Machine_SN, Machine_Type FROM RDC_Store_Machine} AS Machine RELATE Store_ID TO Machine_StoreId)

In the SQL server 6.5 database I have a 1 to many relation between the store and there machine. Every store has a has a record in the machine table so I don't understand where to begin troubleshooting this error. Any suggestions or comments would be greatly appretiated.
Henry