Graham has attended:
Access Intermediate course
Primary Key
is it possible to see which is the Primary key from tabe view?
RE: Primary Key
Dear Graham
Thank you for attending Access Intermediate course. I hope you enjoyed teh course and benefited from it.
Unfortunately the only way you can find out the field that has been assigned as priimary key is either the Design view or the relationship window where you can see the bold fields are the primary key.
The only other way to find out is by common sense. If you see that the data is not duplicating on a field and the heading suggests something like Cust No. or Cust ID, etc... then that will be the primary key.
I hope that has answered your question. Please mark this post as resolved.
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
