1 Reply Latest reply on Jun 10, 2009 2:19 PM by TSGal

    Related Tables and Checkbox Sets

    craig5005

      Title

      Related Tables and Checkbox Sets

      Post

      I have had a weird problem creep up, and I was hoping someone might know what is going on/how to fix it.

       

      I have a table of equipment, and a table of team members.

       

      I want to have a checkbox set of team members on a layout that displays a piece of equipment.  Basically, while displaying records from the equipment table, I want to be able to check off certain team members that have been trained on that particular piece of equipment.  

       

      What I have done is created a simple "one" relationship between the two tables, and made a value list from that table which includes all the team members name.

       

      Depending on how I set things up... I either get a field showing only one name, or I get all the checkboxes, however, when I click on them, they do REALLY weird things.  For example, when I click on the first checkbox, it deletes the first name field from the team member, and then displays the first name of the next person in the list.  The other thing it does is move the second column of team members to the right when I click on checkboxes in the left column.  Everytime I click another checkbox on the left, the right column moves further and further away.  I have NEVER seen this before, and I have no idea what is causing this.

       

      If anyone knows a better way to accomplish this goal, please don't hesitate to let me know.  If someone also knows what is causing these weird actions, plus post.

       

      Thanks

      Craig

        • 1. Re: Related Tables and Checkbox Sets
          TSGal

          craig5005:

           

          Thank you for your post.

           

          Since each piece of equipment can be used by different team members, and since each team member can be trained on several pieces of equipment, this creates a many-to-many relationship.  Therefore, create a third table that joins the different team members to the different types of equipment.  You may have something like the following:

           

          TEAM MEMBER

          Team_ID

          Name

           

          EQUIPMENT

          Equipment_ID

          Description

           

          JOIN TABLE

          Team_ID

          Equipment_ID

          *Date (optional)

           

          In JOIN TABLE, you can enter a team member (through Team_ID), the piece of equipment (through Equipment_ID), and an optional "Date" for when the team member was trained.  At any time, you can see what people were trained on a specific type of equipment, and you can see what equipment was used by team members.

           

          If you need clarification for any of the above steps, please let me know.

           

          TSGal

          FileMaker, Inc.