I'm writing a VB6 application that uses an Access database. It's an application for a clinical research project that tracks patients and their relevant data. The database has several layers of recordsets, ie one patient can have many surgeries, one surgery can have many complications and one complication can have many treatments. I've created an ActiveX bindable control that has the record navigation buttons, and then I bind the relevant text boxes to the ActiveX control. I can get the child recordset to reflect only the records for the parent record, but when I navigate through the recordset, the chld recordsets do not update appropriately. Has anyone had experience with parent and child recordsets that has a better way of doing this?
Matt Weiner, MD
Matt Weiner, MD