Multiple tables linked to single column

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.

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”?

1 Like

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