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
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
