basenine 11/28/2012 6:38:15 PM
No - I'm sorry to say I couldn't figure out a way yet with Anjuim's approach. Here's the steps I've taken so far.... Lot's of backwards and forwarding!
Step 1: I created a third table called Positions and related it to both the Event table and the Result table. Match condition between Result and Position is [Event]
Step 2: created both lookups and summary columns in Positon...went in circles for about an hour...
This didn't really work out as I need to be able to have multiple relations between the Result and Position and this can't be done any other way than manually i.e. no work flow rule
Step 3: Create a relation between Results table and Results table! I didn't know you could do this but I tried it and you can! The idea here was to again select which Results records were slower than the current record.... Didn't work as you need to be able to do a Multi reference column again.... manually add each appropriate record.... Didn't work ;(
So I gave up and thought I'd sleep on it... looks like I might need a few more hours as I woke up with still no clue - *citation: Phil Dunphy!
I really don't think there is a way of doing this other than using the Index method - here, you'd need to create a summary of [Time] and select the appropriate one via index... This could work ok for 1st, 2nd and 3rd...but 500+ positions. Nup!
So, Anjuim - I've probably not understood all of what you've explained fully.
If anyone from TD support can put me out of my misery with a simple solution...or a "No, currently it's not possible"....