Two fields to return another

[pchan]

I am trying to make a database where I can route problems easily. I would like someone to specify a location and a category, then based off of another database with this info it will assign a person to handle the request. So here is a little more info.

Database 1: Where this new request is created

Database 2: Where the information is storied for categories/location/tech is stored.

In Database 2 I have a record that has the following information: Location- Home, Category- Printer, Assistant- Bob.

Now when you specify "Home" "Printer" I need to return "Bob". I can't get this calculation to work. I have tried If statements to say if Location=Home then run this next If statement for the category. Make sense? I am going crazy over this. Is there a way to do this type of filter or two layered search of Database 2 from Database 1?

Thanks, Bryan.

[JerrySalem]

A common trick is to make a concatinated field. Try making a calc field (Location & Catagory). Also make a link field in the daughter db that links a person with a location & Catagory.

Hope this helps.

Jerry