Data Shaping / Hierarchical recordsets

[hdougl1]

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

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

 

[bperry]

Column (Machine_StoreId) does not
exist in the appropriate rowset

Hi there,
I am seriously over my head here, but I notice that the error says (Machine_StoreId), but there is no such column in either Select.

So, either change this:
RELATE Store_ID TO Machine_StoreId)
to
RELATE Store_ID TO Machine_SN)

OR, change this:
({SELECT Machine_SN, Machine_Type
to
({SELECT Machine_StoreId, Machine_Type

-------------------------
What do you think? Could that be it?

bperry

 

[hdougl1]

You are absolutely correct that was it.
Thank you very much!