Want any changes in master table to appear in duplicate table

940 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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,

2 Replies 2

You should use Views for that:

@Elias_Gomez_Sainz I am curious- are there valid use cases you’ve seen of duplicating a table, is the “correct answer” almost always to create a view?