I have created a table tcmcs901 with two fields oldp and newp.
There are two indexes one with oldp+newp and the other one is newp+oldp.
Than I have created a simple stanadard multi-occurance session based on this table. Here , when I click on "Find", It gives me the option of entering the OldP and fetches the newP.

Now, I want a second find option whereby I can enter the newP and baan should fetch oldp.

I understand that this is possible through Viewe->Sort-By.

But the View option of the form is giving me just OldP - New P(i.e. the primary Index). how to get the second index also in the View->Sort-by of form.

Thanks in advance

If I understand correctly then this post should help. Just follow this link (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=1793).

Hope this answers your question.

Mark

maybe you just have forgotten to activate index2 in "maintain session" -> change index.

jochen