I am trying to set up drop down value lists using a relationship to
limit what values appear.
I have department, category, and class fields, where each department
has only certain categories, and each category has certain classes.
I have one table where there is a record for every possible valid
department, category, and class combination that I might eventually
have.
I have used the Define Value list to use values from this table, and
specify category values as only those values where department =
department in that table. This works fine in one table. But when I
try to use the same value list in a different table (same file), it
doesn't work right.
And, in the first table where at least the category seems to be
working right, when I tried to do the same thing to Define Value list
for the class field where category = category, my drop down list for
class shows only the values for the first category value in my list,
no matter what category I select.
I tried making the category = category relationship also include
department = department, but that didn't change the behavior. For
some reason, the drop down value list for the class field is not
changing based on what is selected in the category field--only on
what is selected in the department field.
Can anyone explain what I might be doing wrong, or recommend a
website or reference that explains how to set up this sort of
delimited drop down list more clearly than the Filemaker Help file.
I am obviously not understanding something about how this should be
set up and so far I can't figure out what I am overlooking.
Thanks!
Sue
