Newb Trouble with Conditional List - Help Please!

[FortyWeight]

I'm brand new to FM and this form. I'm working on a database for tracking patient symptoms. I've followed the official FM tutorial, and no joy. I keep getting the "no values defined" message when I try to use the conditional pop-up menu. I've downloaded a couple of examples of working FM files, and yes, they work, but I can't seem to replicate the magic of what they're doing.

I'm looking for an explanation of what I'm missing, rather than just a fix of my file, as I need to generate several levels of complex conditional menus.

An example of part of my DB with conditional lists is attached.

I would appreciate any advice & education that anyone out there could give. If this answer exists in another thread which I've missed please let me know. Thank you all in advance.

test 6.fmp12.zip

[eos]

Your related value list cannot work: Diagnosis is one of the key fields in the relationship to Visit via which you want to populate the value list.

If the field Diagnosis is empty (which it is, since you want to fill it using the value list), the relationship finds no matching records.

If you want to see only the diagnosis values for a given Problem Category from Visit (which I assume is what you want), create a new relationship

based on Problem Category alone, and use that one for the value list.

PS: Is your profile correct? FMP 12 needs as least Mac OS X 10.6, as per the official system requirements.

test 6_eos.fmp12.zip

[FortyWeight]

eos,

I see that your file works, but I'm still working out how to make this work for myself.

You created a table called Visit_forValueList,

However Visit_forValue list does not appear in my list of tables. How did you create this? This must be what I'm missing.

Thank you.

[FortyWeight]

Ahhh, finally figured it out. Needed to dupicate the table in the relationships. Thanks!