LIST function on related records vs scripting a list

[Carole Chaski]

Thank you all in advance for your help and comments! I have two related tables (1 and 2). I used the LIST function on the related table's records to make a list of all the docs in that table (2). I then used a FilterValues function to compare the related records list to a list in the context table (1). The filterValues function results were not correct. Before using the List function (which I thought would be a lot faster), I used a looping script to make a list from all the records in table 2. The filter Values result comparing the scripted related records list from 2 to the list in 1 WAS correct. But I think this looping script could take a long time once table 2 starts to contain 100,000 records. So, does anyone know why the List function method was malfunctioning? or how I can speed up the looping script consdierable? or anything else I might be doing wrong to cause the List function method to malfunction?

Again, many many thanks and blessings to all and esp those who comment.

[Squeaky Data]

I have also seen the list function fail to update on a few occasions and now use a refresh window script step with the flush cached join results option checked which refreshes all the relationships and updates my lists.

I do not know if this will be any faster than your loop script but might be worth a try.

Steve