Hello!

I am going to try and explain this the best that I can. I have a client that wants to replicate child records, but not replicate a record if it shares the same address.

Example:

Child related list (Customer__c) has 4 records. 2 of the 4 records share the same company name and address. 

Tags on the form are as follows:

<<Company_Name>>

<<Company_Address>>

If I add a Table Replication tag in front of Company Name tag, all 4 records will repeat including the records that share an address. 

The requirement is to list each company with name and address, but records that share the same company name and address need to show up only one time.

Example of incorrect format:

Company A

1111 Street

Anywhere, US

Company B

2222 Road

Whatever, PA

Company C

333 Avenue

Huh, WA

Company C

333 Avenue

Huh, WA

Example of correct format:

Company A

1111 Street

Anywhere, US

Company B

2222 Road

Whatever, PA

Company C

333 Avenue

Huh, WA

Any ideas on how to accomplish this? If at all?

Thank you so much!

Shannon