Hi all,
I am new to Dataverse and database design. I am wondering if anyone can help me with the following
We have 3 tables Users, Group and Membership. User tables have customer information, Group table has Group ID and Group name, And Membership table is a fact table that has many to one relationships as shown below,
What we are trying to achieve is
1. When a group becomes Inactive All the rows related to the group in the membership table automatically changed to inactive as shown bellow
2. When a user becomes Inactive All the rows related to the user in the membership table automatically changed to inactive as shown bellow
Also if I know if use parental relations and delete a record then the related record gets deleted. But I can not figure out how to achieve the above but this time instead of changing the status we want to delete the record.
Thanks in advance
