January 9, 2009 02:39pm pst

1. BrandonG... 58,520
2. angelIII 50,475
3. chapmandew 43,095
4. tigin44 34,750
5. mark_wills 19,800
6. mwvisa1 15,802
7. acperkins 14,750
8. Sharath_... 10,650
9. PedroCGD 10,050
10. chrismc 9,000
11. emoreau 8,252
12. Emes 8,070
13. shorak 7,800
14. St3veMax 7,575
15. Juan_Bar... 7,000
16. Qlemo 6,900
17. dbaduck 6,875
18. pratima_... 6,725
19. ScottPletc... 6,500
20. arnold 6,025
21. nmcdermaid 5,000
22. honmapog 4,500
23. appari 4,450
24. tedbilly 4,250
25. expertsoul 4,125

1. angelIII 3,636,840
2. chapmandew 2,841,866
3. aneeshatti... 1,146,706
4. mark_wills 850,066
5. BrandonG... 759,069
6. ptjcb 545,683
7. Yveau 539,545
8. dtodd 492,512
9. momi_sa... 489,969
10. mwvisa1 463,258
11. dqmq 452,536
12. appari 438,824
13. acperkins 410,717
14. PFrog 404,802
15. imitchie 350,938
16. DanielWilson 333,149
17. ee_rlee 324,111
18. EugeneZ 302,944
19. matthews... 295,538
20. ScottPletc... 292,337
21. brejk 268,994
22. PedroCGD 263,797
23. tedbilly 253,979
24. nmcdermaid 239,423
25. Lowfatsp... 235,725

01.30.2008 at 01:17PM PST, ID: 23124379

	[x] Attachment Details

Would like to use one base table to generate primary keys for several other tables....

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.3

Zone:

SQL Server 2005

Tags:

MS SQL 2005

I read an article online not to long ago that described a method in which you could set up an autonumber field in one table and use that field to generate the values for several (or at least one) other tables. I can't find the article, and I have no recollection of what term Microsoft used to describe this.
To clarify the idea is such. We have a contactbase table which generates unique integer values for several other contact tables. Any one entity may be need to be in one or many of the various contact tables that we have. i.e. clientcontacts , customercontacts, personalcontacts etc. Each table has a set of fields that are particular to the type of information we need to store for the type of contact. this ofcourse is designed to follow the object oriented paradigm. Each table represents an inherited form of contact. One entity may need to be classified as more than one type of contact. In these cases we need to use the same contactbaseid for the single entity and enter them into multiple tables.

I am looking for instructions on how to tie a PK on one table to to the generated value from another table.

I realize there may be some issues with trying to put the same entity in multiple tables with this approach, but I would like to at least link a few of the contact tables to my contactbase table.

I wish to avoid the use of GUIDs

Currently we are using procedures to manage this, I would rather manage this at the database level.

Thanks in advance for your help!

#	Title
1	Delete out-of-range AutoNumber Pri…
2	Entity
3	Can a PK be an FK as well ?
4	AutoNumber
5	How can i reset the AutoNumber in a t…
6	Autonumbering Primary key