4 Replies Latest reply: Nov 30, 2012 9:22 AM by Andy Steel RSS

    use value of multi record in LOV in same multi record


      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...


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