Forum Discussion
How to create the right relationship for this table
Hello Everyone, I'm trying to connect data from a certain certificate which looks like this:
The table for which value is related to each class:
| Class | Bending [N/mm2] | Compression [N/mm2] | Holding load [N] | Conduction | Fire-proof |
| 1 | 5 | 2 | 4 | no | no |
| 2 | 10 | 4 | 5 | yes | yes |
| 3 | 20 | 8 | 6 | ||
| 4 | 40 | 20 | 7 | ||
| 5 | 80 | 40 | 8 |
Then I have a table of products that comply with the certification, looking as follows:
| Article | Bending [N/mm2] | Compression [N/mm2] | Holding load [N] | Conduction | Fire-proof |
| ABC-X | 2 | 1 | 4 | 1 | 1 |
| DEF-Y | 3 | 1 | 4 | 2 | 1 |
I want to connect the tables in such a way that the number in the bottom table, corresponds with the number in the upper table. In Excel I would probably do this with some sort of INDEX MATCH but I have to find a way to do this with relationships I think.
Am I doing it with the right approach or do you have suggestions? Thank you!
1 Reply
From what I understand, you want to create a model where the item has the certification class, but doesn't present the physical data. I would split the certification table into several tables, each with its own class requirements ('Bending Cert' table with [Class] and [Bending] fields and so on), and conect each table to the item one in the model.
The second option would be merge the tables several times (one for each requirement) and then expand the requirement. This option would be more repetitive and you'd have to review the steps if a new certification appeared, while the other way you just have to make a new connection.
