3-tier categorization

[Marc54]

Hello,

I'm probably not the first to run into this, but I cannot find anything in the wiki, or here in the forums. Please help.

I'm trying to create a 3-tiered categorization, but I cannot get it past the standard 2-tiers, using either dependent values or using a reference qualifier.

Problem is that when combining the 3 level into 1 table, only 1 level can be set as the display field for that table.

Kind regards,
Marc

[#2]

Have you tried using a choice list, rather than a table?

[Marc54]

It's working.

I created seperate table for category, sub category and subsub category.
In each lower level i created a reference to the parent level.
Then create new reference fields on the incident form that reference the new tables.

The trick: use dependent: on the parent level.

Finishing touch: create client script to clear (sub)sub category fields when category is changed.