Second degree lookup or alternative table set up?

[Per_Carlen]

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!

[Kamille_Parks]

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.

[Per_Carlen]

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

[Kamille_Parks · Accepted solution]

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

[Per_Carlen]

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

[Per_Carlen]

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

Thanks!