Distribution list for actives

[Helder Moreira]

Hello good afternoon,

How can I make a distribution list only for "actives" customers? I have a Table Clientes(ID, name, email, status); Distribuicao (ID, date, distribuicao);  ITEMS "to be distributed" (clientID, DistributionsID). 

i built layout based on Distribution table with one portal of Customers table and another portal of DstLine table that should received only actives selected Customers or all customers.

i tried this script, working only in my computer, when i load on server, becomes to slow and freezes.

It has more than 700 customers.

 

 

[Wim Decorte]

Cross-post with https://community.filemaker.com/thread/175457

(It's ok to cross-post but it is good form to indicate your post as such since a lot of the people on both forums are the same)