CortoMaltes
Programmer
I have created an application in Access 97 for cataloguing of bibliographical information and the data is exported into a text file using VBA, in order to upload the data into our main library management system database.
There is a MAIN table that contains the basic bibliographical data and another table that contains the data that users can choose for a given field, e.g. Authors (within the two there is a join table that links both).
My export code loops through the MAIN recordset and exports everything and then loops through the linked table to export the related data. What I am trying to do is to export the data in an ordered way, to make sure that one full record is exported alltogether before exporting the next record from both the main table and related table(s).
Can anybody help me with the construct of the loop, to have have the data exported in such an order way? Thank you in advance.
There is a MAIN table that contains the basic bibliographical data and another table that contains the data that users can choose for a given field, e.g. Authors (within the two there is a join table that links both).
My export code loops through the MAIN recordset and exports everything and then loops through the linked table to export the related data. What I am trying to do is to export the data in an ordered way, to make sure that one full record is exported alltogether before exporting the next record from both the main table and related table(s).
Can anybody help me with the construct of the loop, to have have the data exported in such an order way? Thank you in advance.