Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Second degree lookup or alternative table set up?

Topic Labels: Base design
Solved
Jump to Solution
300 5
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

Datamodell

1 Solution

Accepted Solutions

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

See Solution in Thread

5 Replies 5

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?

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.

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

Thanks!