sggz813 Posted June 23, 2009 Share Posted June 23, 2009 Hi, is any one can help with auto add reference number?Such as Product ReferenceA 1000001B 1000002C 1000003etc...The number only add 1 each time when you add product.Thanks for the help. Link to comment Share on other sites More sharing options...
jhnstcks Posted June 23, 2009 Share Posted June 23, 2009 Yes I think if you edit the product table in your sql database, you will see that product_id is set to auto_increment, try changing the reference to auto-increment aswell. Link to comment Share on other sites More sharing options...
sggz813 Posted June 23, 2009 Author Share Posted June 23, 2009 Hi, I did try put 2 auto incresment but the error show on below can you advise?#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key Regards Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts