[thelist] FMP 6 Last Record Lookup?

[VanBuskirk, Patricia]

Present Scenario:

We have an Orders database (in FM6), with an online order form that interacts with it.  There are four consultants here who handle incoming orders.  Presently I have a script that uses the budget number from the form to assign the consultant.

Example:  
If(ChargeBudgetNo2>="001000" and ChargeBudgetNo2<="005003","Joe Blow",
If(Charge_RECURRING_Budget_2>="001000" and Charge_RECURRING_Budget_2<="005003","Jerry Jones",
If(ChargeBudgetNo2>="006001" and ChargeBudgetNo2<="008009","Puddn Tame",
If(Charge_RECURRING_Budget_2>="006001" and Charge_RECURRING_Budget_2<="008009","Harley Davison",
...etc....
"Invalid OMNI Dept ID!")))))))))))))))))))))))))))))))))))))))))))))


Expected Change:

We want to look at the last order that came in, find the consultant assigned, then assign the next consultant on the "list" to this order.

I've tried using "last record" in several different ways, but can't seem to get it to work in the script.  

Does anyone know where I would begin on this?