What's recordset2.parentrecordset propery?

  • Thread starter Thread starter markmarko
  • Start date Start date
M

markmarko

I'm wondering what's a good way to relate 2 recordsets (one to many).

I have a form for user to narrow down which records they want to do an
action on. I then clone that recordsource to rsSalesOrders.

The other recordset is SalesDetails (and related data).

What's a good way to relate the two? I found the recordset2.parentrecordset
property, but can find no info on usage. The MSDN page gives little info.
http://msdn.microsoft.com/en-us/library/bb243563.aspx

Any ideas?
 
Have you considered using a SQL to retrieved child record sets like

SELECT * FROM SalesDetails WHERE SalesOrder= SalesID;
 
Back
Top