AnsweredAssumed Answered

Lookups with Case

Question asked by misterg65 on Dec 22, 2010
Latest reply on Dec 27, 2010 by philmodjunk


Lookups with Case


I've got two exams at different levels. The grades depend on which level the student took (A-D or C-G). Currently I have the ID, name, exam level, and mark. I have "lookup" tables for both entry levels. I'm trying for the following.

I can get the basic idea sorted but my problem is the lack of "if this value is not found use the lower value" as seen in a normal lookup field. Having two separate tables for the level is not really an option. I could use Excel, but ... :)

Thanks in advance