Forum Discussion
ReinierZH
3 years agoRegular Visitor
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]...
paladin21
3 years agoRegular Visitor
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.