system
June 29, 2004, 6:55pm
1
Hi
Can i have a prompt like Employee Name and Role Name (stored in different tables but both these tables are joined) and when user select particular employee name for specific role name…role id(stored in same table where role name is stored) should be passed to SQL query?
Please advise.
Thanks in advance
.
Regards
KRG
krgodbole (BOB member since 2003-02-24)
system
June 29, 2004, 9:11pm
2
I think you’ve asked it before. Unfortunately, you can’t do this directly. You can get close using hierarchical LOVs.
Steve Krandel (BOB member since 2002-06-25)
system
June 30, 2004, 3:52pm
3
Can you please brief how we can achieve using hierarchical LOV?
Thanks
krgodbole (BOB member since 2003-02-24)
system
June 30, 2004, 4:55pm
4
system
June 30, 2004, 5:58pm
5
Thanks. I gone through both these posts. It explain how to impelment hierarchical LOV and it also works for me.
But my issue is for hierarchical LOV
Role Id ->Employee Name->Role Name
i want to pass Role Id to Report SQL. But in Prompt LOV it should display
Employee Name->Role Name
Is this possible?
Thanks
KRG
krgodbole (BOB member since 2003-02-24)
system
June 30, 2004, 6:03pm
6
But my issue is for hierarchical LOV
Role Id ->Employee Name->Role Name
i want to pass Role Id to Report SQL. But in Prompt LOV it should display
Employee Name->Role Name
Is this possible?
No. The value selected has to be displayed in the LOV.
Dave Rathbun (BOB member since 2002-06-06)