just need a little advice...again

[faust]

Hey guys, I was just curious. I know that you should always have a unique field in your tables but should you always have a auto increment field? Like id or something? Because if you for example, have table 'products' with catalog codes, each code will be unique, so you actually don't need the auto inc field, right? Just looking for best practices

[mohdharulladtfi]

for me,i using a primary id for each table..example product,i using ProductID for auto increment and catalog codes in other field..i use like this because it easy to refer when we need use 'product' table just using it id..