Forum home » Delegate support and help forum » Microsoft Access Training and help » access class microsoft training - Primary key
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access class microsoft training - Primary key
Resolved · Low Priority · Version Standard
Reply Mon 23 Jul 2007, 09:58Delegate John said...
For upcoming training course dates see: Pricing & availability
RE: Primary key
Hi John,
Thank you for the question
A primary key is a field that is used to uniquely identify a record in a table. The primary key field also helps you to relate two tables.
Tracy
Reply Sun 19 Aug 2007, 14:52Delegate Reza said...
RE: Primary key
Hi Tracey,
I have got two questions; In regards with primary key, how can access increment user specified PK. In other words, if I decide to set my OWN primary key (i.e. 9874, 9875, 9876,...) how can we assign Access to increment by one each time we enter the new data/record in form.
My next question is, I have seen in other forms that once user enters the date into one field, the information for other specified field retrieved automatically. For example, as soon as I insert the Date into my Date Field of my form, the Week number pops out into my Week Number field. I think this is something to do with Lookup/Searching wizard.
Thank you
|