hi friends, i have created a table in ms-access. it contain 7 fields. in it 1st field is customer_id which is set as autonumber type. now i have a doubt of how to provide the value to this table. i dont want to overwrite the autonumber field as well as i need this field to be automaticalls incremented when i enter other field values.
engg_kavi
0
Newbie Poster
Recommended Answers
Jump to PostCan you better describe the problem? I use autonumbers for IDs, which allows the databaes to automatically create them and then I just have to refer to them if I need them. When I use autonumbers, I am not concerned with assigning my own values to them as they are …
All 2 Replies
timothybard
12
Posting Whiz
Can you better describe the problem? I use autonumbers for IDs, which allows the databaes to automatically create them and then I just have to refer to them if I need them. When I use autonumbers, I am not concerned with assigning my own values to them as they are only used to join tables together. Are you trying to assign values to the autonumber field? If so, purhaps using Indexed property of the field would be better than using an autonumber.
engg_kavi
0
Newbie Poster
Thanks 4 ur reply. i could understand the proper use of autofill now.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.