Show referenced tables vs Show referencing tables?

[jay97]

what is the difference between referenced tables vs  referencing tables?

could you please elaborate.

[Allen Andreas · Accepted solution]

Hi,

You should be able to see a slight difference when checking the other box and unchecking the first.

I believe this means:

Show referenced tables: show tables that are referenced from the initial table in question. Meaning this table has reference fields on it that point somewhere else.

Show referencing tables: show tables that point to the initial table in question. Meaning those other tables have reference fields that point to this table.

[Truman Chau]

Can you please explain this in layman's term.  If Table A is referenced FROM Table B, that does mean that the value in A is derived from the value in B?

[Allen Andreas]

Hi,

I tried to provide a breakdown in my original response, but this means that:

• If Table A is referenced FROM Table B...
• then that means in Table B, there is a field that has a reference to Table A

For example...Incident has an assignment group field on it, right? So that assignment group field is a reference to the group table. This means that the Table A (Group) is referenced from Table B (Incident).

The value showing on the Incident is merely just a reference to a specific value on the group table.