1 Reply Latest reply on Jul 3, 2009 10:05 AM by philmodjunk

    Value list of taggs?

    requiredwhen

      Title

      Value list of taggs?

      Post

      I am setting up a contacts database and would like be able to enter into it the project names that an individual worked on. Some people will just have been a part of one project, while someone else might have worked on 3. Is there a type of field, like a value list, where I can manage how the project tiles are spelled, and that can store multiple project entries? My thought is that it would be a value list of tags, but I can't find any documentation for this type of thing.

       

      Thanks

       

        • 1. Re: Value list of taggs?
          philmodjunk
            

          You can set up a table where one record = one project and store your Project Titles here. Now you can define a value list that specifies the Project Titles field in this table.

           

          A pair of design suggestions:

           

          Don't use your Project Title field as the key field in any relationships. If you do and then later discover you have to change the Project Title (perhaps it was misspelled), you'll have problems when you change the name in a table and break the link to any related records in other tables. Instead, base your relationships on an auto-generated serial number field.

           

          Since you have many people working on many projects, you have a many to many relationship. The most flexible way to work with this situation is to create a join table that links to both your personnel and Projects tables. If you are unfamiliar with join tables, click the Advanced search link above to search for threads that talk about a "Join Table".