Getting frustrated with lookupnext function

[faomtl]

Hi everyone,

I'm trying to understand lookupnext function and just can't fugure it out...

My database contains 2 tables.

One is a list of tasks with each task having an id number. The other table is named task, where I have 2 fields; the first being an id number field and the second the "supposed" lookupnext value field calculation.

My goal: I would like when I enter a task number to see in the other field what will be the next task.

ex:

table1

1 = wake-up

2 = breakfast

3 = work

etc...

table2

when I enter the number 2, i would like to get the description "work".

1 = breakfast

2 = work

Can anyone help me. I have attached the file.

Thanks,

Fred.

lookupnext_test.zip

[comment]

LookupNext() looks up the next lower/higher ONLY when there's NO MATCH. If you'd enter 1.5, LookupNext( ... ; higher) would return the value matching 2. A good use for LookupNext() is when you need to lookup within a range.

In your example, you could add a calculation field = TaskNumber + 1 and base the relationship on that.