Hi,
I have product form/table which has productId, productCategorie, productname, etc.
When i want add new product, i select first ProductCategorie ie "10"
Then i made a button to get productID ie: 10001 (10 is categorieID+001)
next add productID if categorie is 10, 10002 en so on.
If...