Skip to main content
Solved

Second degree lookup or alternative table set up?

  • September 2, 2021
  • 5 replies
  • 28 views

Forum|alt.badge.img+2

Hi!

I’ve attached my table connections as an image. Is it possible to to show “Kund” in the table “Uppställningsplats”? If not, what’s an alternative set up?

Thanks!

Best answer by Kamille_Parks11

Thanks, but you can’t do look ups of look ups. Right?


You can, a Lookup field can “lookup” any other field type including other lookups.

5 replies

Kamille_Parks11
Forum|alt.badge.img+27

The Objektsavtal table would have a lookup of the Kundkontakt table’s connected Kund records, and the Uppställningsplats table would have a lookup of that lookup field in the Objektsavtal table.


Forum|alt.badge.img+2
  • Author
  • Inspiring
  • September 2, 2021

The Objektsavtal table would have a lookup of the Kundkontakt table’s connected Kund records, and the Uppställningsplats table would have a lookup of that lookup field in the Objektsavtal table.


Thanks, but you can’t do look ups of look ups. Right?


Kamille_Parks11
Forum|alt.badge.img+27

Thanks, but you can’t do look ups of look ups. Right?


You can, a Lookup field can “lookup” any other field type including other lookups.


Forum|alt.badge.img+2
  • Author
  • Inspiring
  • September 2, 2021

You can, a Lookup field can “lookup” any other field type including other lookups.


Hmm… I’ll have to go back and see why I couldn’t make that work.


Forum|alt.badge.img+2
  • Author
  • Inspiring
  • September 2, 2021

You can, a Lookup field can “lookup” any other field type including other lookups.


Turns out you are correct and my problem is gone! :slightly_smiling_face: I just had to tweak a few things.

Thanks!