I need to set 2 indices on a table:

Terr/cuno/comp/shpt/ctyp/citg/item/year/prno/type
(integer,str,integer,long,str,str,str,integer,integer,enum)

And

Terr/cuno/ctyp/shpt/citg/item/comp/year/prno/type
(integer,str,str,long,str,str,integer,integer,integer,enum)

When I try to set these up - even if I remove my second index and only set up one of them- I get the following error.
"Index has too many parts". This is on my custom table.

I understand that an index can only have 8 parts - according to the HELP. What I don't understand is the relationship of the domain types (strings vs longs). I've seen lots of complex indices in Baan. I've tried combined fields, but this doesn't help either - I can't convert the table def without error.

I need the index so I can sort my data naturally in my session. Users need to input and they need it speedy!

Thanks to anyone who can help explain this to me!

Denise

Ciao, Denise,

I cannot test it now, since it is Saturday, but I think it should work to have 2 combined fields:

cmba = Terr/cuno/comp/shpt/ctyp
cmbb = /citg/item/year/prno/type

And then set the first index as cmba+cmbb.

The same thing for the second index (two combined fields, made of 5 fields each.)

You have said that you have tried combined fields, though....
Is it still not working? Try this, I hope it works.