-
IDENTITY property (autonumber)
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|