Log In    |    Knowledge Base    |    4D Home
Tech Tip: Table access and creating views of multiple tables in 4D Ajax Framework
PRODUCT: 4D Web 2.0 Pack | VERSION: 1.1 | PLATFORM: Mac & Win
Published On: May 1, 2007

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

In the 4D Ajax Framework Control Panel it is possible to create a view which displays fields from multiple related tables. When doing so it is important that the users who are set to have access to that view also have access to all tables used to build that view.

An example of why this is necessary can be shown if you create a view from a One table for a Many table. If the user accessing that view does not have access to the One table they cannot create a record. After clicking the Create button there is a Choose “table name” button, where “table name” is the One table. Clicking that button should allow the user to choose a record from the One table to relate the new record to. But in this case, when the user does not have access to the One table, the window that pops up is not populated with any records to choose from.

To solve this issue log into the 4D Ajax Framework as Administrator and go to the Control Panel and choose the Access Control tab. At the top of the pane there is a drop down menu of users. Make sure the user group that will be accessing the view that has been created is selected. Then there is a check box next to each table designating whether or not that user group has access to that table. All tables related to the view that has been created must be checked for the user group that will be accessing that view.

Once this has been set the window that pops up with data from the one table in the relationship will actually be populated so the user can make a selection and create a new record.

For the latest information the 4D Ajax Framework please see the Daxipedia: