I have merged two files paid invoices and unpaid invoices into one main case table, now in data model, when im assigning case table to activity table it showing error as Could not execute foreign key join: there are duplicates on both sides of

Hello Parvathi,

You might have the same invoices in both the Paid and Unpaid tables, please remove the duplicate from the case table.

For ex: Case key 1111222 data might be able to both the Paid and Unpaid tables, in the case table you should have the either Paid or unpaid invoice data based on the your requirement.

I took invoice Id as case key in activity table, but if i assign paid invoices as case table, without taking merged one, im still getting this duplication error.