1 Reply Latest reply: Oct 23, 2013 3:34 AM by Pars RSS

    Duplicate Recor into TABULAR FORM.

    Vedant

      Dear All

       

      i have created tabular form using SQL

      select

      "LINE_ID",

      "LINE_ID" LINE_ID_DISPLAY,

      "ALLOCATION_ID",

      "SERVICE_ID",

      "CATEGORY_CODE"

      from "HOTEL_ALLOCATION_DTL"

      WHERE SERVICE_ID=:P6_SERVICE_ID

       

      here line_id is primary key .here i don't want to enter duplicate category code when i submit rows.

      Here Allocation_id and service_id would be same for particular service_id .

      How can i create validation to enter duplicate category code .

       

       

      Thanks