Second degree lookup or alternative table set up?

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!

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! :slight_smile: I just had to tweak a few things.

Thanks!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.