This question is locked. New answers and comments are not allowed.
I found 2 ways to create 1:n connections. First one creates an index column to the sub table and the second one would create a link table. Both ways work fine as long as you only use a table for like one or 2 other tables. My problem is that i got a table setup like the one below. It uses one table that is connected to a lot of other tables in a 1:n connection.
tbl_Equipment
- IdEquipmentType (PK) <- 10 = tbl_User, 20 = tbl_Car, 30 = tbl_House, 40 = tbl_Pet
- Id (PK) <- Id at the table
- EquipmentName
tbl_User
- Id
.....
tbl_Car
- Id
.....
tbl_House
- Id
.....
tbl_Pet
- Id
.....
Using one of the ways above would either result in x additional tables or x fields added to it, while x is the number of tables connected to it. Is there another way to solve it ?
Best regards,
Adrian
tbl_Equipment
- IdEquipmentType (PK) <- 10 = tbl_User, 20 = tbl_Car, 30 = tbl_House, 40 = tbl_Pet
- Id (PK) <- Id at the table
- EquipmentName
tbl_User
- Id
.....
tbl_Car
- Id
.....
tbl_House
- Id
.....
tbl_Pet
- Id
.....
Using one of the ways above would either result in x additional tables or x fields added to it, while x is the number of tables connected to it. Is there another way to solve it ?
Best regards,
Adrian