Feb 10, 2019 10:37 AM
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,
M
Feb 10, 2019 01:27 PM
You should use Views for that:
Mar 25, 2020 12:25 PM
@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?