Question

Entity association with more than one columns

0

Hello, Here is my scenario, Please advice to achieve this, there are 2 tables like PROCESS & USERS(Association has done with one to many ) Process table contains two columns like APPROVER AND LEADER both can be difference person Create a new process record Reference selector included in the page for user selection but if I change APPROVER then the same username applied to LEADER as well. How to solve this one?

asked 2018-12-06

Selvaraja Harichandran

1 answers

Dave Timmer · Answer 1 · 2018-12-06

Hi Selvaraja,

Create two associations between Process and User (singular).

Name the first Process_User_Approver and the second Process_User_Leader.

This way you can set two users for different roles, but you need to have two reference seletors as well, one for each association.

Hope this helps!

Cheers,

Dave