AnsweredAssumed Answered

How to remove duplicate portal records in a remote table.

Question asked by muhammad.ikram@contedia.com on Nov 22, 2018
Latest reply on Nov 22, 2018 by okramis

Hello Community,

 

I have an remote table in FileMaker called DeliveryAddress. It is linked with customer table. So a customer can have many delivery address.

 

I have layout for customers. On customers layout I have a portal which shows related delivery address of customers. However, the are number of same delivery address in show in portal.

 

This is my relationship.

 

<<Customers>>-----<<DelivertyAddresses>>--------CustomerID

 

WHat is the best way to hide the duplicates from the deliveryaddress portal on customer layout. Isit even possible.

 

I tried researching through but could not find any solution.

 

Thank you in advance.

Outcomes