I have a 14 column table which starts off at 88,000 rows. I then filter it for rows relevant to me and it drops to 12,000. As I second step I would like to “extract” out 4 columns to make a second table. The remaining table then having only 10 columns. Should I change the filter in the primary table (10 columns), it must “ripple through” to the secondary table (4 columns). Which means it can’t just be a duplication, and it can’t just be another source connection.
I have struggled with referencing as I do not want duplication of columns in the two tables. If I delete a column in the referenced table, then it causes problems in the latter table.
Anyone got any ideas?
Thanks in advance,