I have 3 tables: Links, Namespaces and Servers.
The “Servers” table has a field for “Environment” (TEST, LIVE, DEV)
The Namespaces table is linked to Servers.
The Links table is linked to Namespaces.
On the Links table, I have a lookup field for Server. This shows what server a link is on, based on the linked Namespace.
How can I also add “Environment” to the Links table? Link > Namespace > Server > Environment.