I notice that your function definition allows a list to be passed as searchValue. This would allow you to find the start of a a sequence in indexValues.
Have you ever made use of ths feature? For instance, this would work:
CorrespondingValue( "A¶B¶C¶A¶C¶D"; "A¶C"; "1¶2¶3¶4¶5¶6")
I notice that your function definition allows a list to be passed as searchValue.
It doesn't disallow it would be a more accurate statement. I am not sure where the application of such feature would be useful.
Can you set up a relationship between the two tables, sort by the time and then take the information from the first record? If sorted correctly shouuld be the fastest time.
Yes, try Bruce's idea.
You don't even need a portal, just the fields for time and it's date from the sorted relationship, because the first record in the sort will appear in a non-portal field instance.
Thanks, the sorting works great, but I wanted to combine different sort of games, in this case different kind of skate distances in one table. With the sorting I need to create for every skating distance a table. I couldn't find the function(?) correspondingvalue. Is there a solution or is the best way to create multiple tabels?
One way to do this is to create a global field and use that in the relationship. Populate the global field with a list of values you want in the other table. You can then sort them with multiple fields to put them in the order you want.
You can also show the records with key fields in a portal if that will be helpful.