0 Replies Latest reply on May 25, 2012 8:48 PM by moj6054

    Code for Product

    moj6054

      I have a Group Table in in this table have some record (Board,CT,Cable ,....) and each record have some ID like (200;210;220;....)

       

      and a product table, two table linke with category:categoryID ----- product::categoryID

       

       

       

      in product table when I want add new record first choose category (example Board) and then add product description (example PWM), Qty (10) price (15$) and....

       

      Now I want a script do this:

       

      when I choose category, go to category board and how many record i add before (example 5) and then create a new code for this last record some code like:2006 ( is 6 record in this group)

       

      and again for new record in CT group :2101(1 for first record in this group and for second 2102 and ...)

       

      in Cable group :2201

       

       

       

       

       

       

       

      for add each recotd in each group , add new code for last product

       

      thank you for your help.

       

      i use this database for my stock, and I want to add code for product in each group.