Copy fields from Securkty Incident to Response Task

[Community Alums]

I have two tables: Security Incident and Response Tasks.

There are about 20 fields I want to copy down to the response task when created. What is the best way to relate the two to be able to add the fields to the response task?

[Community Alums]

Is there a way to relate the two tables so I can just add the same fields to the response task?

[AshishKM]

@Community Alums , yes we can do that, the main point is "how this response task" are created, ideally if it's are part of some logic with security incident it means, these tasks are created by system and there must be linked via some field ( like parent column ) otherwise the response task will be stand along record.

Refer the details shared by @Maddysunil , you can create a reference type field on response task  table and apply the logic in BR ( if applicable ) provided the BR table and trigger point which is entirely depends on use case means "who its triggering, incident or task".

If you are trying this logic on response task level and on update of incident column [ which you created as per details given here ] then the BR [update ] will trigger on response task table and read the data from incident , update on response task. 

So you have options, need to analyze the use case and technical implementation.

-Thanks,

AshishKM