This discussion is archived
4 Replies Latest reply: Nov 30, 2012 7:22 AM by Andy Steel RSS

use value of multi record in LOV in same multi record

garcol Newbie
Currently Being Moderated
Hello,

I have created a multi record tabular form (report actually). Some fields are select lists with of course an LOV. I would like to use a value of each current row to use in the LOV to make it dynamic.

This is the where clause of the LOV:
and rda.tsr_code = :P1103_TSR_CODE (TSR_CODE is a column in the multi record)

But that is not working, it works when I use:
and rda.tsr_code = 'M' (but that is not very dynamic and I have to make numerous different LOV's...)

After reading several pages, I could not find a solution...

Anyone?

Edited by: 960788 on 23-sep-2012 13:56

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points