Wed 17 Dec 2008, 11:03Delegate 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:13Trainer 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
