How to pass ID field from LOV 1

[Videla]

Hi All,
I am using Business Objects XI R2 version. I have a question.

I have a table with three columns like this

ID Name Salary
1 Siva 100
2 Raja 50
3 Raja 40

Now I have provided the users to select the name from the LOV.
Users can see the List of Names like this
Siva(1)
Raja(2)
Raja(3)
I want to pass the ID field when they select name to the database.
How can I pass ID field instead of Name?
ANy help would be much aprreciated

 

[skrandel]

You can do this using the index aware capability in Designer. You tell it what fields to use this with and it works great.

Steve Krandel
Symantec

 

[DrSmyth]

Steve,

Browsing through the forums and spotted your post... This is a fantastic tip, not used the index aware function before seems to speed up my query execution time..

Have a star