Showing linked records across tables

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

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. :slight_smile:

1 Like

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