I have inherited a VB6 project written using DAO on largely Access data.
The code is poor and the application often generates a Windows crash (program "has encountered a problem and needs to close") with large sets of data. I suspect large parts need rewriting.
I want to start with using DAO to relate a recordset of invoice headers (which has one record per invoice) and another of invoice lines (which has several records per invoice). Two fields link these recordsets: Date and Reference.
Though I have seen an example of creating a DAO.Relation, I have no idea how to use it and would welcome some advice please.
If you're looking for a feature like .Net hierarchical datasets, there's nothing like that in DAO or ADO.