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

    Code for Product


      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.