Primary key and first field in a table... | Access forum

Resolved · Urgent Priority · Version 2003

Wed 17 Dec 2008, 11:03 Delegate Emma said...

Emma has attended:
Access Intermediate course
Access Introduction course

Primary key and first field in a table...

Does thje first field in the table have to be a number? Like account number etc? or can it be text? and also can i confrim that if so this would be the primary key?

Wed 17 Dec 2008, 15:13 Trainer Pete said...

RE: primary key and first field in a table...

Hi Emma,
Thank you for your question;
In reply: No it does not have to be a number, you can use text for a primary key as well, the only stipulation is that it must be unique... ie for a Department Table, MK for Marketing, SA for Sales, FI for Finance all perfectly acceptable, account number could be a mixture of both ie company name and number Tesco = TES01 -- get the picture?
I hope that helps ...Pete

Wed 24 Dec 2008: Automatically marked as resolved.

Training courses