Showing linked records across tables

Daniel_May · ‎Jun 22, 2020

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

ScottWorld · ‎Jun 22, 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:

See Solution in Thread

ScottWorld · ‎Jun 22, 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: