For example, when i key in all the required information, then it will display out the matching information only at the bottom. Attached is the screenshot of the session.

Hi,

Is this post related to another post/question?

Actually is getting same result, but in different method.

Can you please elaborate more on your issue?

How to add another find option in the standard Find Dialog box?

In case you want to add a fifth 'sort by' then you need to enable on session level another index.

For example, i use standard table tfacp200, when i create a new session which contain this table, it will give me all the record. But i want to customize a session which contain 3 fields, Fiscal Year, Fiscal Period and Business Partner. After i key in information in this 3 field, it will display out data only base on this 3 field condition.

I did in the coding part, its duplicate all the value. I want something like the Find icon command on top of the toolbar, but it doesn't contain all the 3 field that i want.

How to enable it since i don have that field in my index key?

I have merged the two threads together since I think the are related.

To add an index to a table you should start with the Table Definition session (ttadv4520m000), find your table, then double click it (you might need to copy it to your VRC if it is not already copied), go to the index tab and your index carefully there. Check the screen shot. For the full process check this link:
http://www.baanboard.com/baanboard/showthread.php?t=36481

- George

Hi George,

I try the method that you suggest, but i get an error saying that Fatal error : Error 1308 (database error 308) on select and another Fatal error : Cannot continue in tfxxx2500m201 in DLL: ottstpstandard (rcdset.readnextrecords)[sql.fetch]

How to solve this?

Please refer to this attachment.

Please refer to the link (http://www.baanboard.com/baanboard/showthread.php?t=36481) I posted earlier for the full process of adding a index to a table.

Hi George,

I already follow the exact step from the link, but don't know why still getting this error messages.

This error occurs if an array column is indexed outside its dimensions:
http://www.baanboard.com/programmers_manual_baanerp_help_errors_308_ESQLINDEXOUTOFDIMS

Can you double click the new index you have added and send us the screen shot so we can see how did you define your index

- George

Hi George,

Please refer to the file that i attached. It is the step on how i create the new indices.

It probably has to do with the fact that this index is not unique. As you can see for the other indices, all the fields of index 1 are always added to the other index. So add the fields ttyp, ninv,...,lino to this new index.