Anyone know of some great techniques for "categorizing" a value list generated from field?

I have a ValuesTable (Three tables make this, ValuesSet, Values List & ValuesLine) I use to store all my Assignment Types. The list has grown larger then expected and is hard for users to read through. I would like to categorized them in some manor to help this.

For example:

SERVICES

- Design

- Writing

- Motion Graphics

PRODUCTS

- Printing

- Ad Specialties

- Signage

If you can help or point me to some good material to read/view I would really appreciate it. THANKS!

Edited December 4, 200916 yr by Guest
removed shouting.

Hi,

Since you are using multiple table, have you considered using relationships to filter your value list.

If you setup a Category field in your ValuesTable. You can create a field in the same table where the current field that is attached to the value list exists or if you use a resource table you can place it there(either way lets call this TableInUse). You can make it a global or local field depending on your preference. This new field will be to hold the Category, the value list for this can be based off the Category field in your values table. In your relationship graph you can add a relationship from TableInUse to your ValuesTable and it will simple be an TableInUse::Category = ValuesTable::Category.

Now all that is left is to go to your original value list in question, and check "Include only related values starting from" and set it to TableInUse. Now when a user selects the Category, the will see only the corresponding values.

Hope this helps!

Yes, I am using this relational hierarchy collapse of values already.

Tho some of the list are still long. I need a way to populate a value list with categories within it.

I guess I could add a fourth ValueTable.... but just seems overkill to me.