I gathered from what I read that this issue is open for debt. I think I'll test it on one of the smaller primary tables in development to see...

Thanks for the information on my first two questions. As for the third, users can search on a combination of nine different fields which involves more than one primary...

Matt, that was perfect. I hate how easy you guys all make it seem. I screwed around with Case statement for an entire day. Thanks again.

Thanks for the responses. I downloaded the census data and it will do for now. Now I have a follow up question as it relates to these tables.

I...

Okay. A followup question then: when I go to restore the files to the new server can I change where the tables are stored (which file group)? Right...

I got the Insert into suggestion working without a problem. Question: something I should have mentioned is that there are a couple of million FileNumbers in the reference table...