"Dynamic" Value List working but not...?

[ron G]

I have the relationship above. Proficiency POPUP and Proficiency POPUP 2 exist to provide means to have a 'dynamic' value list.

HERE IS A SHORT EXAMPLE:

The two fields above are 'degree' and 'description'.

There are 3 degrees but there are 'many' of them. Each degree 'row' has it's own 'description'.

I want the user to click the degree. Select from the dropdown and then according to what degree is selcted, have a limited selection in the next dropdown field.

This seems to work with this unusual exception. When I click the Degree popup, I get this:

1

1

2

3

It should be:

1

2

3

If I click the 2nd '1', I get a single popup in the neighboring, "descripton", popup. If I click the 1st '1', I GET ALL THE DESCRIPTIONS.

Does anyone know what's going on?

Thanks for reading.

[ron G]

Thanks to JM Osborne and his sample file, I got it to work... (Hope it sticks with me this time)...

ConditinalValueList.zip