Auto number in a query

[Sed]

Yes, my new db may primary keys, however I'm just a beginner in access. This db was written from somebody else. My boss wants me to redesign something like this for our parts division. I'm trying to do my best. I've gotten this far by asking you guys.

 

[vbaInet]

You are awesome, thanks a bunch. If you are ever in Atlanta, let me know, I owe you a few beer.

That would cost you

Can I ask you one more favor? In my main form, right now it's reading from "shipper" table, I want it to read from "dbo_supplier" table and keep my combo box as is. I'm not good with forms.

I guess if you want to use a different record source you create a new form based on that new table (or source), i.e. dbo_supplier. If it's more complicated than that then this question would be more suited to be in a new thread.

Yes, my new db may primary keys, however I'm just a beginner in access. This db was written from somebody else. My boss wants me to redesign something like this for our parts division. I'm trying to do my best. I've gotten this far by asking you guys.

You need to read about normalization:

http://support.microsoft.com/kb/100139
http://r937.com/relational.html