A student marries and changes her name. Another student complains his name is "Smythe" not "Smith". In both cases, when you correct the name in the Students table, you break the relationship to the records in the other table.
Is there something I should be concerned about as far as creating a gigantic table like that?
Hard to answer without knowing what "Records" are in real life.
OK, thanks. I am convinced, but I want to make sure I set this up correctly.
Students Table:StudentID = auto-generated serial #
Records Table: StudentID = text or number
Yes. It's best to use the same data type for both fields.
BTW, you do not have to remember the StudentID. You can use the name for finding records, etc. Once you set it up, you can forget it exists.