AnsweredAssumed Answered

Newbie - primary key for product database?

Question asked by QuickRon on Apr 18, 2010
Latest reply on Nov 24, 2013 by NormanSaxon

Title

Newbie - primary key for product database?

Post

I'm working on creating a Products database, where each product code (or sku) is unique and alphanumeric. For example, ABG624397-CXC would be one product number. 

 

In this situation, what would be the best practice regarding the primary key? Is it okay to make the actual Product Code the primary key? Or is it better to create a separate field that is an auto-entered Serial number as the ID for the product?

 

Thank you.

Ron

 

Outcomes