im an extreme newbie trying to create a database for my middle school classes. i teach lot of different classes, so in logging my information i was wondering if there is a way to have the value of the 'grade field' (which is a drop down list from 5-8) define which value list will be used in the 'teacher' field, thereby minimizing the number of names that need to be scrolled through. for instance, once 6 is chosen (as in 6th grade) only the value list with 6th grade teacher names is available for the 'teacher' field. alternatively, if 7 is chosen, only 7th grade teacher names are available in the 'teacher' field.
i just began using filemaker pro 5 last night, so my familiarity is limited. will a script be required or is there an easier strategy?
thanks for any help
