Skip to main content

Nested or Double lookup?

  • February 28, 2017
  • 3 replies
  • 55 views
S
Forum|alt.badge.img+3

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.

      3 replies

      S
      Forum|alt.badge.img+3
      • Scorance
      • Author
      • Participating Frequently
      • February 28, 2017

      Basically I want to do a lookup on a lookup:

      A
      • Andrew_Keppel
      • New Participant
      • March 1, 2017

      I agree! Dotwalking would be immensely helpful and would extend the usefulness of the app a great deal. Both being able to access reference fields in filters or in the formula field-type.

      E
      Forum|alt.badge.img+17

      You simply need an extra table for the Enviroments. More complex but more flexible.

        Terms & ConditionsAccessibility statement