Hi all.

Using SLX LAN v7.2.1. We have a listbox on a form where the end user adds item numbers. I want to be able to search a table (myTableA) based on the items entered in the listbox. So when the click the "DISPLAY RESULTS" button it will display the resuls (itemnumber, quantity, uom etc.) in the datagrid. The number of items that are entered in the listbox varies (1 or 10 or 20 etc.).

Any ideas?

Thank you in advance!

Very simple..

1. pass the item numbers as comma separated values in a SP which in turn will get the records from myTableA using the condition

    where itemnumber in (comma separated string). Capture these values in a temp table and use that table as data source for the datagrid

or 2. strore the listbox items in a table and join this table with myTableA to get the datasource for datagrid.

let me know if this makes sense to you..

Haren