We have a database with 7,000 items and we would like for the user to be able to enter a few items of their choice without using a 7,000 line list, so can this be done using dev studio, I have no java or html programmer

If someone an example, it would be well appreciated

thank you.

This message has been edited. Last edited by: YKK,

People have discussed this before. You could include a textarea where the user would enter the selected item numbers, separated by commas - that would be sent to the fex as one variable which you use in a WHERE statement, something like:

WHERE ITEM_NBR IN (&ITEM_NBRS);

You may need to insert single quotes in the variable before using it in the WHERE statement.

There may be better ways to do this...

I dealt with the same issue and got some good responses in this topic:

http://forums.informationbuild...=422100725#422100725

I opted with a text box not text area and a '+' delimiter since my users are mostly keying in numbers using the keypad. Text areas are goofy in different browsers especially chrome.