I need help! I am new to SQL server and want to know how IDENTITY property works.

I migrated MS ACCESS tables to SQL Server (upsized) domain but found out none of the subform tables functioned.

For example, one form has the following table structure:

Order (main form)
|
Order_details (sub form)

In this case, Order_details subform does not inherit serial numbers (autonumber) which are supposed to be passed on from Order main form. This means that I can enter header information but order details.

Could someone help me on this?

I also want to find good, easier reference manuals on SQL Server programming. The books I have here are TOO TECHNICAL for novices like me:
- Inside Microsoft SQL Server 6.5 (Ron Soukup, 1997) and
- Hitchhiker's Guide to Visual Basic & SQL Server 6.5 (William R. Vaughn)

Any help will be greatly appreciated.