Rotation for assigned technicians.

[DHyMan]

So I have an app completely done except that ticket assignments. My app creates, tracks, and manages Support Request tickets. I only have two techs for each department. I would like for it to select one and then the other. So every new ticket it would be a new tech(different from the last choice) each time. And of course from the same department. Please help. 

[Marc_Dillon]

Lookup the previous ticket's tech value with:

LOOKUP( MAXROW() , table , key , tech )

Then apply a simple IF statement on that value to choose the alternating tech. Something like IF( {sub-expression} = "John" , "Tim" , "John" )

[DHyMan]

I’m gonna try that. Let ya know.  Thank you!