Valuelist with rellations SLOW!!

[Jokez]

I have a rellationship to show a field in a value list from only some of all records in a table. If I tell the valuelist to show all values (7400) it goes fast, if I show the values from a limited rellationship then it goes dead slow, slow like we can go and take a coffe break wile we wait, and thats is just 3800 values! How can I make this faster??

Plz need help!!

Regards Jocke

[Sanjai]

I don't know why it is performing slower but can you try creating a calculation field which if matches your relationship criteria would show the value else it would be empty. Index the calculation field and make the value list to be created based on the calculation field.

[mr_vodka]

Please do not double post.

The other thread can be found Here.