How to build relationship between incident table with custom table

[Srinivasu2]

Hi Community,

How to build relationship between incident table with custom table, like user table with roles table

Whenever user create a new field with value in incident form will automatically create that field and value custom table

Thanks,

Srinivasu 

[Brian Lancaster]

There are 3 tables involved when in comes to the relationship between user and role.

sys_user - This contains the users

sys_user_role - this contains the roles

sys_user_has_role - this contains a reference to the user table and the role table.

So basically when you add a user to a role it is creating a record in the sys_user_has_role table that has the user and the role. In one record.

Can you explain more on what you are trying to do so we can better assist you?

[Srinivasu2]

Hi @Brian Lancaster ,

Thank you for assisting me with this. Actually, we have created a case form in the CSM Portal, which automatically generates an incident when configured through the flow designer upon the creation of a case.

Additionally, we aim to create a custom table. In the future, if someone adds a field with a value in the incident table, it will automatically be stored in the custom table.

To start this process, we need to create the custom table and establish a relationship with the incident form.

Thanks,

Srinivasu