Build a relation between 3 tables, each other.

[Alfonso Olalde]

I have a problem with the implementation, I'm going to explain it:

The model of risk administration of my client is based in "Causes", I mean, 1 risk could have 1 or more Causes, and these are related with controls too. In this case (Causes related with controls), 1 control could cover 1 or more causes.  I created a custom table named "Risk Causes" and I added a relationship between the tables "Risk statement" and this table. 

The question is, How could inherit the attributes of table Risk Causes, to the tables Risks and Controls? 

I created an attribute type "Reference" but it didn't inherit the register selected by the user in the beginning of the relation (Table Risk Statement).

I hope that I have been clear, but if you have any doubts or questions, please let me know. 

Thank you very much for reading me, and sorry for my poor English. 

[Rajesh_Singh]

@Alfonso Olalde 

1. Create a reference field in the "Risks" and "Controls" tables to establish a relationship with the "Risk Causes" table. For example, you can add a "Risk Cause" reference field in both the "Risks" and "Controls" tables, referencing the "Risk Causes" table.

2. Create a business rule or script include to inherit the attributes from the "Risk Causes" table when a new record is created or updated in the "Risks" and "Controls" tables. This will ensure that the relevant attributes from the "Risk Causes" table are automatically copied to the "Risks" and "Controls" tables when a user selects a risk cause.

[Alfonso Olalde]

Hi Rajesh, 

Thanks a lot for responding my question, I have a couple of questions about it:

1. In your opinion which scenario is the better to implement? I'll create a relation such as "extended table" or create a many to many relationship?

2. Can I create a query to inherit attributes in List attribute type or only with a business rule its ok?

Thank you very much for your time. 

---------------

Best regards 

Alfonso Olalde