How do i get the key from the value display in prompt? e.g. i have prompt where it display the product name. How do i get the product ID from the product name selected by user?
I would like to get the project ID from =userResponse() so that i can pass the product ID into my detail report.
Please advise.
bobj_bedum (BOB member since 2013-07-19)