Searching Multiple Fields in a Find
I am using FMP 11 Advanced on a FMP 11 Server. I have a "work order" database in which jobs that come in are assigned to specific techs. When tech 1 finishes their specific function, they re-assign the work order to tech #2 (from a drop-down list) to complete their specific function, and then on to tech #3, etc. Up until now, I have had one "tech assigned" field which made the "find pending jobs" for a particular tech easy. I have created more tech assigned fields (tech 1, tech 2, tech 3, tech 4) so I can keep track of when a tech is assigned the work order and when the next tech gets the re-assignment. When the first tech finishes their assignment, they will reassign the work order to another tech using the tech 2 field, and when that tech finishes their assignment, they will reassign the work order to another tech using the tech 3 field, etc. Not all work orders will use all 4 tech fields.
My problem is in writing a script so that I can find current pending work orders per tech. So how would I write (I am not a programmer) "if tech 4 field is blank use tech 3 field (assuming tech 1 and tech 2 fields are used), if tech 4 field and tech 3 fields are blank use tech 2 field, if tech 4 field and tech 3 field and tech 2 fields are blank, use tech 1 field?
I hope this make sense. Thanks!