4 Replies Latest reply on Oct 15, 2009 1:17 PM by ravisub

    Is it possible to have multiple related entries within a single record?

    ravisub

      Title

      Is it possible to have multiple related entries within a single record?

      Post

      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

      Record2: Name2->N2Address1

      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,

       

      -rs