Data Shaping problem

[dbrom]

Hi,

I use data shaping to return a child recordset as a part
of the parent recordset. The parent recordset contains
models from the Models tables, and it is supposed to have a
field rsAccessories that would have all accessories for this model from Accessories table.
Here's my SQL statement:


SHAPE {SELECT modelName FROM }
APPEND ({ModelsSELECT filename FROM Accessories}
RELATE modelId TO modelId) AS rsAccessories


However, when I open the recordset, I get the
following error message:


MSDataShape error '80040e14'

Column (modelId) does not exist in the appropriate rowset.


Both tables, Models and Accessories, have modelId column.
Here are all columns in both tables, just in case:

Accessories:
modelId; filename; width; height; active

Models:
modelId, modelname

Thanks in advance.
Hope you have any ideas what the problem might be.

(-:
Dmitriy
dbrom@crosswinds.net

 

[dbrom]

any ideas? Dmitriy
dbrom@crosswinds.net