469,575 Members | 1,668 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,575 developers. It's quick & easy.

AutoNumber field in a form Access 2007.


I am mainly a MySQL user but I have been playing with Access 07 a little bit recently. I created a database with 3 tables.

Table ID ---
userID -- AutoNumber
UserInfo - userID (linked to ID.userID
fname -- text
lname -- text
age -- number
Usermoreinfo - userID (linked to ID.userID)
college -- text

So i made a form using the 'form wizard' and i assumed that because userID is an autonumber field it would've just automagically inserted a row in that table/field first because everything else relies upon that. I was wrong, so i created a second form with all of the above fields.

So now i have a form with:

fname lname

it wont let me do inserts because it tells me userID is an autonumber field if i enter anything in that text box, if i dont enter anything in that text box it tells me the primary key cant be NULL... kind of a catch22 huh??

can anyone explain this to me? i could do this with MySQL in two queries by just getting the last insert id but i'm trying to do something different/new.

thanks for any advice.
Dec 7 '07 #1
1 2822
167 100+
hi BMF!

You seem to have a problem with ID table. Basically it's not needed! You should put the info about one entity into only one table. (User is an entity for itself).
Try to change your tables as I did in Test file attached to this reply.
I hope this design will be acceptable for you.

I'll be here for future questions you might have.
Attached Files
File Type: zip Test-v1.zip (29.3 KB, 174 views)
Dec 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Ed Havelaar | last post: by
3 posts views Thread by Ralph Birden | last post: by
3 posts views Thread by ThompsonJessical | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.