Working with multiple Database(s), multiple Table(s)
I just purchased the DA 2.0.8 Extension and ran thru the Wizard multiple times.. very nice.
But on the first page of the DA Wizard, I do not see any way to work with a Recordset, only a "single" Table?
- It only gives you the option to choose Database/Table
- I have multiple Database(s), each with multiple Table(s)
- How do I Reference or access the other Database(s) or Tables using DA?
In the past, I would create my Recordsets first, from multiple Table(s) then use this as the Source for my Forms..
I tried to go back and "change" the DA querysource after running the wizard, creating my full Recordset, including my other tables, but it crashes all of the pages..?
Question: What is the proper way to work with multiple tables and DA wizard?
Thanks,
ja