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