Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Multiple tables linked to single column

Topic Labels: Base design
216 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a base for tracking servers thru a migration.

Tables

  • Servers
  • Databases
  • Migration Date

I need to associate Servers and Databases to a Migration Date. The complexity is that I need a view showing all Servers and Databases (along with some supporting data points) for a single migration date.

If I add a Migration Date lookup to both Servers and Databases tables, I can’t figure out how to create the view so each Server and Database for a specific Migration Date are listed 1 per row.

1 Reply 1

A single Link to another record-type field cannot link to multiple tables.

How critical is it that Servers and Databases have their own table? Can they be in one table and differentiated by a Single select-type field for “type”?