This setup doesn't work because there is a relationship included. It works if you avoid the relationship and do it all in one table in indexable fields.
Repeating fields and relationships don't go well together. Historically this is because the repetition fields are predating the relationhips.
Hi! Thanks for the reply!
If I put my reference repeating field in the table it will have to be a global. I have experience of this slowing down when I get to large record counts !
However ... There no point in not giving it a go !
I have fond remembrance of the uses of repeating field since FMP 1.0
In this case it's going to save me sets of calcs that comes in 50's !!!!!
and Merry Christmas from NZ (where it is already Christmas day!)!
Consider having a short try with the webviewer. I tried to post a CF here but wasn't successful because the CF contains HTML which makes the forum software confused. Parts of the CF are removed.
You find a demo db at barchart.zip. In contains a Custom Function which is only accessible using FM Advanced.
It gives pictures like this: