>If my primary key is an unintelligent key that's an integer type, I can use only 4 places. What if I have more than 9,999 records in the table? Am I missing something fundamental?
>

Jane, while an Integer field only occupies 4 bytes, it can store a much larger range of values because the values in the 4 byes are binary. The range of values runs from - (2^31) to (2^31) -1, or about 4 billion discrete values.

>Thanks.