Master table to combine ID from different tables (to slice) (every value just once)

[herbemischung]

Hello,

i have 5 Tables, each of them has a separate ID.

It is the same ID in all of the tables and every table has every ID just once! BUT there is no Table with all IDs. So it is not possible zu create a Relationship between all Tables.

As every Table has different Columns, I don't really want to create one monster of a table. I would prefer to have an extra table with every ID from all Tables (just once). Then I could create 5 1:n relationships.

Is that possible?

thank you!

[herbemischung · Accepted solution]

okay, I found the solution on youtube: 

https://www.youtube.com/watch?v=vAvQ8pCnWDk