6 Replies Latest reply on Feb 20, 2017 8:31 PM by philmodjunk

    Script help?

    jiang_aq

      I have a database, for example:

       

      Company        Order#

      A                     PM001

      A                     PM002

      B                     QCB00001

      C                     DQK001

      C                     DQK002

       

      I wanna write a script for adding new order:

       

      If new order's company = A, then Order#=PM003

      If new order's company = B, then Order#=QCB00002

      If new order's company = A, then Order#=DQK003

       

      Thanks in advance!