troubleshooting Question

To search a child datawindow for a value to be set in parent datawindow.

Avatar of Mateen
Mateen asked on
Editors IDEs
2 Comments1 Solution530 ViewsLast Modified:
pb7

Window Name : w_vchr_type_users
Datawindow Name : dw_detail  ( Columns = [user_id],[company_code] )
Child Datawindow name : dddw_user_id   ( set on field user_id Displayvalue=user_id datavalue=userid)

dddw_user_id has following rows.
user_id    company_code
Rizwan     16
Mateen     01
Nadeem     01
Rizwan     01
Rizwan     02
Asghar     02
......     ..

I WANT TO POPULATE COLUMN COMPANY_CODE in DW_DETAIL AUTOMATICALLY.

If the user select (Rizwan) 1st row in the dddw_user_id then company_code to be set auto is 16
If the user select (Rizwan) 4th row in the dddw_user_id then company_code to be set auto is 01
If the user select (Rizwan) 5th row in the dddw_user_id then company_code to be set auto is 02



ASKER CERTIFIED SOLUTION
diasroshan

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros