Link one field to multiple tables?

HI! I have a mushroom farm and we are looking to use airtable to track our lab work.

Each table represents a different lab item, (Liquid Cultures, Agar Plates, Grain Spawn bags, Substrate Bags)
and each Lab Item has a “Source” which could be any of the other lab items.

How can I have a “Source” field in the Substrate Bag table that links to items in the other Liquid Cultures, Agar Plates and Grain Spawn bag tables?

Many Thanks!

Would really appreciate any input!

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