Help

Re: Multiple tables linked to single column

426 0
cancel
Showing results for 
Search instead for 
Did you mean: 
keith_kwasigroc
4 - Data Explorer
4 - Data Explorer

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