AnsweredAssumed Answered

Dwindling Value List Issues

Question asked by disabled_morkus on Nov 3, 2015
Latest reply on Nov 3, 2015 by disabled_morkus

I have been going through the excellent YouTube tutorial on Dwindling Value Lists, but for some reason, although everything I'm doing looks the same, the dwindling part isn't working ... I still see all values in the list.

 

I have a Vendor table, a categories table, and a vendor_categories table.

 

I have a calculation field defined in the VENDORS table to be "CATEGORIES_SELECTED". This field, for now, is just a calculation: List(VENDOR_CATEGORY::CAT_FK).

 

Per the video, I then relate this field to the TO for Categories TO I called "CATEGORIES_NOT_SELECTED"

 

 

I created a value list corresponding to the categories not selected like this:

 

 

I changed the field on the layout to use the new dropdown value list:

 

 

After still allowing me to enter duplicates (for some reason the dwindling value list ... isn't), I see this in the VENDORS:CATEGORIES_SELECTED field:

 

 

The value list dropdown, even though, as shown above, I'm using the "<>" relationship between vendors and "CATEGORIES_NOT_SELECTED" (the separate categories TO required), also shows that I can keep picking the same value over and over:

 

 

A bit frustrating.

 

Would welcome any suggestions.

 

Thanks,

 

- m

Outcomes