Want any changes in master table to appear in duplicate table


Hello, newbie here.

I know how to duplicate a table. But how can I ensure that changes made to the original/master table are automatically reflected in duplicate tables? Such changes could be adding/removing entries, changes to (drop down) options, insert/removal of fields, etc.

Purpose of duplicate tables is to group the info in the original/master table by different fields (e.g. original table is grouped by field “Name”, duplicate table 1 is grouped by field ‘Age’, duplicate table 2 is grouped by field ‘Height’, etc).

Thank you,


You should use Views for that: