0 Replies Latest reply: Jun 24, 2013 3:28 AM by sam8682 RSS

    list item problem in oracle forms 6i

    sam8682

      Hello,

      I've 10 test filed, in-front of each text field there are 10 list item (separate list item)
      for each list item element list is given below

       

      Route

      Customer name

      Delivery date

      Delivery Time

      Delivery Session

      Expected received

      Actual Received

      Fresh Received

      Rate per liter

      Debit Amount

       

      On text fields I am fetching records from another file. User will map the list item with text item.

      What i want to check is, list item should not get repeated. i.e suppose I've run time display like this

      text itemlist item
      A

      ROUTE

      BDELIVERY DATE
      CDELIVERY TIME
      DDELIVERY DATE
      EEXPECTED RECEIVED
      FACTUAL RECEIVED
      GFRESH RECEIVED
      HRATE PER LITER
      IDEBIT AMOUNT
      JDELIVERY SESSION

      on text filed B- DELIVERY DATE is assign and at text field D again DELIVERY DATE is assign. I want to avoid this thing and prompt the user regarding the same. How should I go about this? Should I design a button for validation, if yes then what should be the code? or should i go with WHEN-LIST-CHANGE? if so, then what should be the code?

      my design time display is like this

      text list item
      txt1lst1
      txt2lst2
      txt3lst3
      txt4lst4
      txt5lst5
      txt6lst6
      txt7lst7
      txt8lst8
      txt9lst9
      txt10lst10

       

      please suggest something

       

      Thank You

      Sam