Hi,

In Baan V, The item domain tcitem is segmented with project.
So... wherever this item needs to be selected... the project is always part of it, if project is present.

It is possible that Item No. 100 in present in multiple Projects.. say A, B & C
So Item master tcibd001 will have records as..
A 100
B 100
C 100
100

How is it possible to create an index on only the Item segment ?

I can select only the item segment programatically.. but can i create a index and be able to select only the item.

I was thinking of creating a new domain with just the item length of say 38,
add a new field to tcibd001, populate that field with the item segment values & add a new index to the table.

I'm sure there is a better way. All suggestions are welcome. Thanks

Regards
Little John

Or you could fill in Search Key II with this, that's already index 3. Seems to be what they did in the test data we have here.

Hi Lisa,

Thanks for your response. Thats a great workaround... but am limited to 16 characters. But this should work for now... but I'll eventually have to do something to utilize all the 38 characters or just shoot the user if he uses more than 16 :)

LittleJohn

There is a field (dfit) derived from item that can be used.

Yikes - dead users are not happy references!

One last shot, the Derived from Item field - is that by chance filled? I thought it would fill with the base item, but I do see some on my test data that are not filled in. Maybe it even fills with another project item, it's the domain tcitem as well, so not sure there. Maybe check your data and see, our data is pretty unreliable. It's also an index.

Also, one of our clients did change the segementation from project / item to item / project. Damned if you do damned if you don't on that one. I think they eventually changed it back, too many other issues.

Oo sorry nabbi0, looks like we over posted. At least we agree :)

The tcibd001.dfit field is of type domain tcitem... so cannot use that, as Lisa pointed out... lotsa errors on that front.

I think i'll continue using the Search Key II .... and till such time.. the user is spared :)

Thanks for all the replies.

Hello

The field dfit is filled on request if you copy a standard item to a project item and you would like to keep the connection to the standard (has somthing afterward to do with requirements planning). Thats the way it behaved in Baan IV.
So, I would not put values in that field, which are not for this purpos.

/Lakoon