Separate column in connected tables

1

Hi, I have two tables that are connected to each other. This means that if I enter something into a column, regardless of which table, it will automatically be entered into the other table. Is there a way that I can create a column in the second table that is not automatically entered in table 1? I know that the column in table 1 is then automatically made non visible, but is there a possibility that it does not appear in table 1 at all? Also not as invisible?

Briefly asked: Is it possible to create a column in a connected table that is completely not connected to the other table?

2

Hi

What you are describing does not sound like two connected tables, but rather one table with two views.

Technically you can only add a column to the base table, but whether that column is included in any view is optional, giving you what you are looking for