set up linkage between the main table in parent page and the sub table in child page

[Pinky Hui]

I have built a main table in the parent page and built a sub table in the child page.

For the sub table in the child page, I have set the restriction. Only the responsible persons can view and edit the page. For the main table in the parent page, only I can edit and every one can view only.

Now, I would like to set auto-update for the table. Example, the person edit in the sub-table , it will be auto-updated in the main table. 

I have used "Excerpt Include" and "Include Page" Macro before, but I only want to auto-update the number in the sub-table to Main table. Besides, if I use these two macros, the display of the table will be poor. 

May I know how can I set up linkage between the main table in parent page and the sub table in child page? Thanks.

[Andrey Khaneev _StiltSoft_]

Hi @Pinky Hui

I think this can be done with the help of Table Transformer macro (Table Filter and Charts app).

In my example we have a page with a table:

Then we include this page to another page using Excerpt Include macro and lookup it with another table using Table Transformer macro:

Let me know if this is close to what you need.