i'm working on this access DB that has the following tables, fields (I need), and primary and forigen keys.

** = primary key
* = forigen
- = field.

Library Information
** ID
- Library Name
- Address1
- Address2
- City
- State
- Zip
- Library Type

Library Project
** PROJ_ID
* LIB_ID
- proj_name
- proj_budget

Shipping Log
** SLT_ID
* PROJ_ID
- ship_date
- attetion_of
- cd_cs_person
- lst_pricing
- spec_notes

Shipping Log List
** LST_NAME_ID
* SLT_ID
- list_name
- titles_on_lst
- list_amt

all the primary keys are Autonumbers. If i pull these tables into a dataset and add new records to the dataset and then load the dataset back into the database, what happens with the primary keys that are autonumbers? does ado.net know or somehow make the autonumber, and what about if someone else is also adding. sorry about all the questions. but like i said before with many of my post i'm still learning, so please bear with me...and thanx for any and all help