Skip to main content

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

Reply


Terms & Conditions