Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Multiple tables linked to single column

Topic Labels: Base design
193 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”?