How to create the right relationship for this table

[ReinierZH]

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!

[paladin21]

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.