I am making a kind of ticketing system. It will require several views 
(setranges) such as viewing tickets assigned to certain individuals or 
everybody, open/close tickets, by due date or priority and many more.

The easiest thing is to just define all the secondary indices that are 
required. The problem is that I worry about corruption.

As an alternative I was thinking of having multiple tables with a few SI 
each and keep them in sync. On the form the user would click the view 
they want and the fields would be redefined to reflect the table with 
the required SI. That sounds like a headache.

I am interested in hearing about other possibilities. Thanks.

Peter