3 Replies Latest reply on May 4, 2014 12:35 PM by SteveMartino

    all in 1 table??

    smithsmith

      Title

      all in 1 table??

      Post

           Helloo guys,
           i need to create a db.

           my informations are:

           name,lastname,country,city,address,birth,weight,height,job,sex,car and one container with photo.

           what you suggested to do?all in one table or more tables?

        • 1. Re: all in 1 table??
          philmodjunk

               Maybe, maybe not.

               This appears to be a list of contacts.

               Could they have more than one address (such as a billing address and a shipping address)?

               If you need to record a phone number, many people have multiple phone numbers. Do you need to record such phone numbers?

               Might you need to record information for more than one car?

               Might they work more than one job?

               An answer of yes to any one of these questions suggests that you might want to set up a related table so that you can record a flexible number of instances of that data for that one contact.

          • 2. Re: all in 1 table??
            smithsmith

                 each person has one car one job

            • 3. Re: all in 1 table??
              SteveMartino

                   Did you take a look at the Contacts Starter Solution?  Might be all you need.