Database Connectivity - Master/Detail Controls

Create a master page and add a connection, recordset and your dynamic controls.

Switch to the Database toolbar and choose the "Master/Detail" option - do not click the arrow, but the main button. Now select a saved data connection and the field name which will act as the link.

Fill in the detail page filename and select an application server, which you can confirm by pressing "OK".

Move the cursor in the master page to where you will display the database fields, then move to the region where the linked field will link to the detail page. Using the menu on the "Master/Detail" button, choose the "Master" option, which constructs the necessary link to your detail page.

Now construct your detail page, again, using the Connect/Recordset controls. Select the SQL statement in the detail page code and delete it. Using the menu on the "Master/Detail" button, choose the "Detail" option, which will allow you to display the detail field.