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

In most cases, child tables are used as options for the parent, for example, take a products Database

you may have a products table and a categories table where the product can be assigned to the categories.

In the wizard, set the categories column to use a meny form elements type, then click the lightning bolt next to the menu to edit it;s properties, and set it to use the categories table, with the category ID as the value and category name as the label.

If you have a more complex table structure, you may need to build on the pages after the wizard has been created, for example adding the Manage Relational Table behavior to the insert and update behaviors if you have a linking table.