Matt,
You can build a statement
IF ( Contains([LOCATION],"Milton","Oakville","Mississauga") AND
Contains ([WORKTYPE],"Spill","Containment"), "Emergency Response",
Next set of conditions, ....
Is there a deeper relationship you can build and exploit to get your result so that you do not have to create a massive If Statement?
I am assuming that your users type in a [LOCATION] from information about the customer so there is an unlimited amount of possible answers. If "Spill" and "Containment" are always going to be "Emergency Response" then you could have the table where you need the information "Emergency Response" inherit from the relationship.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------