Is it possible to have multiple related entries within a single record?
I'm trying to make a database as follows: name of person, and all their old addresses (the number of which can be different for each person). The database of names seems simple enough (even for me..), I could make one record per name. But I don't know how to do the second part. If there was a fixed number of addresses, e.g. 3, then I could have 3 additional fields called address1 through address5. That would be kludgy, since some might only use 1 and other might use more, but it would work. But I don't know how many addresses there will be for each name. Besides, the addresses are going to be different for each person, so its not as if the addresses could all live in a different table (maybe I'm wrong about this). If I could do linked lists, it would be something like:
Record1: Name1->N1Address1, N1Address2
Record3: Name3->N3Address1, N3Address2, N3Address3.....
I was told to go look at related tables for this, but for the life of me I can't figure out how this could work. I'd be very greatful for pointers. Thanks,