AnsweredAssumed Answered

Conditional Value Lists

Question asked by Kaps_1 on Feb 24, 2011
Latest reply on Feb 24, 2011 by philmodjunk


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 !!!