4 Replies Latest reply: May 4, 2016 1:36 AM by muhammad fahad RSS

    making table through if statment

    muhammad fahad

      I have a database table like this

       

      DemandNoITNoQuotaionNOTenderNOPoNO
      abcxyzs3ss312348910
      deferfyuee2313
      ghiyuitt4s
      jkltre

       

      this is a table of purchasing system: Demand no is assign to demand (requirement) generated by user each demand is then process to different stages. IT, Quotation, Tender, purchase order.

      now the value in the field identifies the stage of demand.

      e.g

      demand abc is complete because it has no null value.

      demand def is in tender stage because tender id is assigned to it.

      demand ghi is in Quotation stage

      demand jkl is in IT stage..

       

      Requirement:

      now I want to show the table like

       

      DemandStageDone
      abcITy
      abcQuotationy
      abcTendery
      abcPurchase_ordery
      defITy
      defQuotationy
      defTendery
      defPurchase_ordern

      and so on

       

      any body can help or any body can suggest the better solution to identify the stages of a demand.?