On Table tccom012/013 (Customer Postal/Delivery Addresses), there are two indices available

1. Customer, Address Code
2. Country, Zip Code, Customer, Address Code

But on session Display Customer Postal/Delivery Addresses (tccom012m000/tccom013m000) only first index is available. When I added the second index as well and tried to do a search after picking the second index, it still displayed the fields from first index as a search option.

I guess it is due to the Form Type 3 with view field as the second index did not have the view fields as the first two fields of the index. Actually I tried to find a session with form type 3 and multiple indices and couldn't find one as an example. So I guess there is kind of restriction on how the multiple indices can be put on a session of form type 3 (and it makes sense too) but would appreciate any feedback that you might have on this.

Thanks in advance.

Hi,

Did u check whether the order by shows both the indexes and if no goto maintain sessions and maintain indices in special menu check the second index also.

For the search option to show the secondary index you have to be to select the second index in order by or you can even start the session by default with second index.

Regards

Yes, I can see the second index in 'Order By' and even can select it. After selecting if I try to do a search.. it will still show me the two fields that are part of first index.

Hello,

I think that you need to have 2 forms with different index. Look at session ticst0101m000 you have two forms and two different selection. But to do this you need to have access to the source and insert in the before.form.x an instruction to.key(x)

Regards
Philippe

Hi,

if you want to use the second index for search you have to put the fields "tccom012.pstc" and "tccom012.ccty" on your form with field type "Input" (although they are just display fields).
Now you will be able to search by their values after sorting by index2.

Yes the fields should be of type input. Otherwise you can manipulate in the choice option also.

Regards

Thanks guys. By setting the fields as Input, the search option properly displayed the fields to be search on when index 2 was selected.

On the other hand, the session started behaving strangely and one couldn't scroll through records as one normally would do.

But thanks for the tip.