>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?
>
>Thanks.

While an integer is stored in only 4 bytes in a file... it actually has a range of +/-2 billion and change. So, you can store 2345678 (etc) in an iteger field.

BOb