Account has relationship with table A Contact has relationship with table B.
On Table B we have columns like
ColumnA1 ColumnA2 ColumnA3 ContactLookUp Designation
R1 R12 R13 Contact Developer
R1 R12 R13 Contact Architect R12 R122 R132 Contact Architect R12 R122 R132 Contact Architect
Here ColumnA1 + ColumnA2+ ColumnA3 is the composite key
So based on the Table B data we need to create unique records in Table A with the counts of Developer or Architect.
So in Table A we will have 2 Unique records considering the Composite key of table B
Table B Columns are like this
AccountLookup ColumnB1 ColumnB2 ColumnB2 Developer Architect Contact.Account R1 R12 R13 1 1 Contact.Account R12 R122 R132 0 2
Could anyone help me in this scenario. Thanks in Advance.