I'm attempting to implement a rather simple form in VB6 with a one to many
relationship between Table A and Table B (e.g. Customers and Orders). The
backend DB is Access 2002 and the connection provider is Jet 4. I have an
ADODC to navigate through Customers and fill in corresponding data-bound
textboxes. This works fine. I have a DataGrid with a second ADODC that uses
a separate connection and a command RecordSource of "Select * from Orders
where customerid = '" & CustomerIdTextbox.Text & "'". I reset the
RecordSource of the Orders ADODC within the MoveComplete handler of the
CustomerADODC. This works fine.
But, if a Customer has no Orders, then the OrdersADODC won't allow me to add
new Orders records from within the DataGrid. What additional event handlers
need to be written and which default ADODC properties need to be changed?
Forgive me my ignorance - I've studied the included online help and some
Internet faq material but haven't yet stumbled over an answer to this
seemingly common pattern...
Oh, I don't believe I want a FlexGrid because the Customer information isn't
presented in table format. But, maybe I'm wrong. Perhaps the FlexGrid
control has the logic to handle multi-table recordsets even if one isn't
presenting everything in grids...