Exercise 14: Appending data where there are nested tables

The mechanism for updating nested tables (tables within tables) is very similar to updating a single table except that nested tables have an outer row number and an inner row number.

We'll take a look at appending and prepending rows to an outer and inner tables in this exercise.

As before, we'll use the Events module:

mod_events_nested3_train.gif

When a row is selected in the Tasks table (the outer table), values in the fields above are updated. Three of these fields above also happen to be tables (tables within a table, hence the name nested table) - Assigned To: (Task Information), Notify: (Commencement) and Notify: (Completion) - containing lists of Party names (they are thus both a table and an attachment field).

The fields used in this exercise are:

Field

Back-end name

IRN

irn

Description: (Task Information)

TasDescription_tab

Assigned To: (Task Information)

TasPersonAssignedToRef_nesttab

Assigned By: (Task Information)

TasTaskAssignerRef_tab

Date: (Commencement)

TasCommencementDate0

Notify: (Commencement)

TasStartNotifyDate0

Completed: (Completion)

TasCompleted_tab

  1. Locate the Events record you created earlier. You will have recorded the IRN of this record at Step 4 of Exercise 11.

    The Tasks tab of your Events record will be similar to this:

    mod_events_nested3_train.gif