Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompts with decode

Status
Not open for further replies.
jennyfher

jennyfher

MIS
Oct 8, 2003
23
US
Hello:
I have this data: data_id, data_description

I have a prompt with values data_description, now I want to have the prompt showing the data_description to the user but using the data_id to make the query. I am thinking this can be done with a decode...but I am not sure how. Any ideas
 
Sort by date Sort by votes
Just use a custom LOV. Show both the id and the description. Sort by description.

Steve Krandel
VERITAS Software
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JOEYB99
  • Locked
  • Question
Problem with Webi Hyperlink to SAP t-code CATS_DA
Replies
0
Views
443
JOEYB99
JOEYB99
RB3
  • Locked
  • Question
Searching for Fields With a Question Mark Character Contained Within Any Position Using WildCard
Replies
0
Views
178
RB3
RB3
lmonk01
  • Locked
  • Question
BO CMC running report with Access datasource
Replies
2
Views
229
hilfy
hilfy
PWD
  • Locked
  • Question
Sub-Sections Within A Report
Replies
1
Views
203
PWD
PWD
Pookeye
  • Locked
  • Question
Running Crystal Reports in Business Objects 4.1 with Universe as a Datasource.
Replies
0
Views
163
Pookeye
Pookeye

Part and Inventory Search

Sponsor

Back
Top