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

    all in 1 table??



      all in 1 table??


           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??

               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??

                 each person has one car one job

            • 3. Re: all in 1 table??

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