Build a relation between 3 tables, each other.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2023 04:09 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-26-2023 12:21 AM
-
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.
-
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.
---------------
Regards,
Rajesh Singh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2023 01:03 PM
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