Hierarchial recordsets, recursive relationships in Access
I am trying to represent a recursive relationship in an Access table in a
MSHFlexGrid control... The easiest way I see is to get a hierarchial recordset
with the SHAPE command, and bind that to the control. This works beautifully
from SQL Server, but I can't get Access to take the SHAPE commmand.
How would one go about getting a hierarchial recordset out of Access?
If there is a better way to represent a recursive relationship in a MSHFlexGrid,
I'm open to that too, but quick & dirty is the key... Also, the control automatically
sets up expanding/collapsing when it's databound to a hierarchial recordset...
I'd rather not have to code those behaviors...
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center