Text to Variable

[#1]

Hi guys im having a bit of a problem here is the deal, i have a table from a database with a field called "Company_ID" and at the end of the load script i have a where clause that goes like

From report_data.Table1 where Company_ID=1 or Company_ID=2;

Now i want the user to be able to choose the companies to load, the only problem is i cant use a predefined value on a variable as the user doesnt not know the Company IDs but only names.

I have tried using a load inline like:

Load * inline[
ID, Name
Company_ID=1, Intel
Company_ID=2, Microsoft
Company_ID=1 or Company_ID=2, Both

and setting a list box on the front end with the "Name" of the listbox and a variable that equals the ID field, the problem is when i do this either with

var1=ID

or Var ID

etc the variable on the script pick the word "ID" instead of picking the value selected for the field ID.

How do i make this work for the user to have company names and the script loads the ID's??

Many Thanks

[#2 · Accepted solution]

Ok i have managed a solution, which was make 3 Load Inline staments, and then on the Front end,

Settings>> Document Properties, On select Load inline 1 set variable to Company_ID=1 on select Load inline 2 set variable to Company_ID=2 whilst applying rules to deselect the other List boxes when a new is selected.

Hope this Helps Someone.