Help

Second degree lookup or alternative table set up?

Topic Labels: Base design
Solved
Jump to Solution
1147 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Per_Carlen
7 - App Architect
7 - App Architect

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!