Conditional Value Lists
I can't see the wood for the trees !!!
I am trying to set up a conditional value list and can't get it to work.
I have fields called "specialities" and "episodes". These are in a table called specialities.
I have created a table called "clinic episodes" - which has a field called specialties. I have created a link with the field called specialities between the tables "specialties" and "clinical episodes".
I have used a value list in the field called specialities (in the clinical episodes table) and taken the values from the "specialities" field in the specialities table. I can see the specialities correctly.
I have set up another value list using values on the first field "episodes" from the "specialities" table. I have told it to use only related values from the "patients" table. The layout is based on patients. There is a relationship between the "patients" and "episodes" table. However I cannot see any value appear in "episodes" on the clinical episodes.
I have looked at my previous examples and also the standard one on filemaker.However, I can't see what I am doing wrong !!!