conditional value lists do not work
I have a short question about a problem I have with the use of conditional value lists.
I have a database with products, and those products can be divided into categories, sub categories, and sub-sub categories. What I would like to be able to do is create a layout where I can add new products, after first selecting the category, then the sub category, and then the sub-sub category. The problem is that eventually the list with sub-sub categories will be huge, so it would be nice to have a conditional value list based on the other tables.
I however do not seem to be able to make it work and I can not figure out what I am doing wrong. I made a functional conditional value list based on the instructions in the FM help section, but this one does not work.
The fields I have in the different tables are the following:
- category name
- sub category name
- sub-sub category name
- sub categoryIDfk
- product name
- sub-sub categoryIDfk