1 Reply Latest reply on May 8, 2009 11:19 AM by philmodjunk

    records with multiple last names

    wflc

      Title

      records with multiple last names

      Post

      I am in the process of building a contact file.  We maintain information on women participants in our programs as well as couples for events and donor requests.  I am unable to determine 1- how to enter different last names for couples.  ie: Mary Jones and Sam Smith.

      Thanks.

        • 1. Re: records with multiple last names
          philmodjunk
            

          You have several options:

           

          1) use 2 last name fields and two first name fields in your record (simple but messy).

          2) Make your table structure more sophisticated.

           

          You could make a "people" table with the following fields:

          First Name

          Last Name

          CoupleID

           

          Make your other table a "contact info" or "Couples Info" table give it whatever fields you now have for recording data on your couple, addresses, phone number, etc. but add one more field: CoupleID and make it an auto-entered serial number.

           

          Create a relationship: People::CoupleID--=--ContactInfo::CoupleID and enable the creation of related records in the People table.

           

          Now put a portal on your contact info table to display related People records.