Need Help!!! Getting two fields to determine another one.
I was wondering if there is a script or something to determine a field based on two other fields. I'm trying to create a database for a small company that has people register over the phone for programs and classes. There are different levels of classes/programs based on the persons age or skill level. Dates and time of classes depend on the location and ofcourse the class, and level of the person signing up. Is there anyway that when I am entering data that the dates and time for the class are already figure out. So when im registering a person for a class in a specific location for a specific level, that dates and time are already determined in another field.
I know this might be confusing but all help is appreciated.
For example,if a person registered for [Basket Weaving; Advanced; Cook County], the applicable classes could be shown in a portal to Classes matching on Topic, Level and Location.