ADODB Recordset for More than 1 Subform 1

[paulgenga]

Is it possible to open a recordset with multiple subforms
i.e append more than 1 ChildCMD.

Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "SHAPE {" & Sv1 & "} AS ParentCMD APPEND ({" & Sv2 & " } AS ChildCMD RELATE LotID TO LotID) AS ChildCMD", db, adOpenStatic, adLockOptimistic

 

[jebenson]

Absolutely. Here's an example from on of my old projects:

"SHAPE {SELECT * from Bond} APPEND ((SHAPE {SELECT * FROM Maturity} APPEND ({SELECT * from TPFADS} AS DebtSvc RELATE ID to MaturityID)) As MaturityDebtSvc RELATE ID to parentID)"


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[paulgenga]

Thank you Mr Simpson,
I am a great fun. This works great
J.Bravo