Place link in multiple categories

[sooskriszta]

This is somewhat related to my 2 other threads
http://www.nicecoder.com/community/f...d-fields-9305/
and
http://www.nicecoder.com/community/f...tegories-9286/

In 2.4, IndexU allows users to add a link to up to 3 categories via dropdowns.

I'd like to let users to select unlimited categories for each link. From an interface perspective, all that needs is change from dropdown category selection to checkbox (or accumulator) category selection. But I suppose potentially there could be backend changes needed....

Thoughts, anyone?

[sooskriszta]

The current database structure is not amenable to that....it's very restrictive.

Instead of having 3 category fields in the link table, I would strongly recommend:
- remove all 3 category fields from link table
- create additional table: category to link with only 2 fields....category id and link id
- use joins with this new table to display, edit etc links

This process completely severs the parent-child relationship between categories and links, and instead opens up a many-to-many relationship, which is much more flexible and helpful.

Developers?