AnsweredAssumed Answered

Code for Product

Question asked by moj6054 on May 25, 2012

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.