Log In    |    Knowledge Base    |    4D Home
Tech Tip: How to create a View for related tables
PRODUCT: 4D Web 2.0 Pack | VERSION: 1.0 | PLATFORM: Mac & Win
Published On: March 29, 2007

PLEASE NOTE: This Tech Tip applies to 4D Web 2.0 Pack version 1.0

Views in the 4D Ajax Framework (4DAF) can be created for related tables in order to consolidate fields from many related tables into one virtual table. To create a View for related tables follow these steps:

  1. Login to the 4DAF Client as Administrator.

  2. Click the Settings button and go to the Access Control tab.

  3. Select the one table, and then click the New View button. You will see
    a pull-down menu of related tables.

  4. Select a table from the list and click Go to create the View.

  5. The View is now created at the bottom of the Portlet list.

  6. Select the View and you will now see fields from your related tables in
    the Properties area.