Multiple tables linked to single column

[keith_kwasigroc]

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.

[Kamille_Parks]

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