looking up next higher value

[johnrh]

I am providing a solution for an athletics club that requires me to enter an achieved time in file1 which will then lookup a corresponding number of points that tim equates to in file2.

The problem is that the times in both files in many instances will not be EXACTLY the same.

Suppose the following is true

Points File (File2)

Points Time (sec)

100 25.0

105 25.5

110 26.0

115 etc.. 26.5 .....

I need to enter say a time of 25.7sec and lookup the exact points value or if that does not exist the next higher value in File2 - in this case 110 points

I need therefore to show 110 points in file1

But I cannot see how to set up the relationship between the two files. I cannot believe that I am the only one who has run into this sort of problem. Is there any of you guys out there who have solved thais sort of thing or can give me some advice please

Thanks again

John

[Ugo DI LUCA]

Relationship Time::Time

Define you "points" field to be a lookup from Points in the Points file using the relationship

Check "Use next value if not found"