Skip to main content
Solved

Showing linked records across tables

  • June 23, 2020
  • 1 reply
  • 10 views

Forum|alt.badge.img

Hi,

New to AirTable.

I’ve got tables that look like:

  • Courses (links to Units)
  • Units (links to Modules)
  • Modules (have a field called Video)

A Unit will have one or more Modules. I know how to show Videos for a given Unit via lookup of all the Modules for a Unit.

A Course will have one or more Units. What’s the best way in AirTable to show the Videos for a Course?

Thanks,
Daniel

Best answer by ScottWorld

Welcome to the community, @Daniel_May!

Same thing you did when you linked your Units table to your Modules table.

Just create a lookup field in your Courses table that pulls in the Videos lookup field from the Units table.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

1 reply

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9778 replies
  • Answer
  • June 23, 2020

Welcome to the community, @Daniel_May!

Same thing you did when you linked your Units table to your Modules table.

Just create a lookup field in your Courses table that pulls in the Videos lookup field from the Units table.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face: