Using Cascade parent/filter fields

omroepmuseum

Well-known member
You are using DaDaBIK version 13.3-Levanto platinum, installed on 31/01/2026 (installation code: 133315a7493334bfea), the latest version of DaDaBIK is 13.4-Levanto released on 18/03/2026

You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.

In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.

System info​

PHP Version: 8.2.30

mysql version: 10.6.24-MariaDB-cll-lve

Web server: LiteSpeed

Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36 Edg/146.0.0.0

URL installation:
Hello,

in our application we have a field "Category". Recently I added a field "Main Category". Both fields have their lookup tables. In the lookup table for Category there are two fields (apart from the third PK-field), one for the Category name and one for the correspondent Main Category this Category belongs to. And of course this Main Category uses the lookup table for the main categories. Now I added cascade parent/filter fields in our main table of all the devices to limit the choice of categories to the categories available in the corresponding main category. Works fine.
BUT: sometimes we can have the same category-name in multiple main categories. For instance, you have the categories "Mixer" and "Recorder" in both the main categories "Audio" and "Video". Or "Measuring Device" in even more main categories. And also that is possible without any problem.
UNTIL you list such a device in the grid view and the appear MULTIPLE TIMES (for "Mixer" and "Recorder" exactly two times).
Is there a way to avoid this phenomen?
Or do my categories really need a different name for EVERY category?

Kind greetings,

Hendrik
 
Top