Does anybody know, why I cannot use

[AtharIqbal]

Does anybody know, why I cannot use the Grand Child's Name as DataSource.

Here is the code....It gives me error when I try the set the datasource as TasksCMD...Error is "Item not found in collection corresponding to name or ordinal"

rsText = "SHAPE {SELECT * FROM Projects} AS ProjCMD " & _
"APPEND " & _
"((SHAPE {SELECT * FROM SubProjects} " & _
"APPEND ({SELECT * FROM Tasks} AS TasksCMD " & _
"RELATE ProjID TO TaskProjID, SProjID TO TaskSProjID) " & _
"AS TasksCMD) " & _
"RELATE ProjID TO ProjID) AS SubProjCMD"

adoPrimaryRS.Open rsText, db, adOpenStatic, adLockOptimistic

Set grdProjects.DataSource = adoPrimaryRS
Set grdSubProjects.DataSource = adoPrimaryRS("SubProjCMD&quot.UnderlyingValue
Set grdTasks.DataSource = adoPrimaryRS("TasksCMD&quot.UnderlyingValue

Any help will be appreciated....

 

[rtrajkov]

That message means that it cannon find the table column which you have requested.

Either SubProjCMD or TasksCMD are invalid column names.