Chapter 9 – Event Management Template

Exercise 1

Currently, in the A_Sessions table, data from the Location and Capacity columns is added manually for each session that is added to the table. To keep the mapping consistent, we need to have a single place where the data for the location and its capacity can be added. This exercise can be done in two ways.

Solution 1

Perform the following steps:

1. Create a new table and name it M_Locations.
2. Rename the first column of the table Location and the second column Capacity.
3. Fill this table with unique Location values from the A_Sessions table along with the correct Capacity value in the respective columns:

Figure 9.1 – The M_Locations table

4. Select the Location column in the A_Sessions table, set its format to Rowlink and picklist, and select the M_Locations table as the source. This will change the format of the entire column and automatically convert the cells into...