1 Reply Latest reply on Nov 22, 2015 7:27 PM by CarlSchwarz

    Join Fields Many to many relationships

    pjpique

      I have currently set up a solution to track service jobs.  I've done this by setting up a join table which works well between projects and equipment; as one project can have many pieces of equipment worked on, and one piece of equipment can be worked on throughout the years on different projects.

       

      I've come across a case when in one of the jobs that makes date entry impossible to track with my set up.  Normally date is included in the project table.  However, there are times when on the same project we might make multiple trips to site to install different equipment so each piece of equipment installed has a different date.  Sure I could move this to the equipment table, but when there's a different project with the same equipment it will just replace this value.

       

      I've tried to include the date field in my join table so that different dates could be used on projects and equipment, however, when i simulate, the equipment has the same date across projects.  I think that maybe the problem lies in that I included the date field from a different table in the sub portal for equipment.

       

      Either something is not set up correctly, or maybe i need to make the same fields in projects and perform some kind of copy move.  I'm not exactly sure.

       

      Thank you in advance for your suggestions and help.

       

       

      PJ

        • 1. Re: Join Fields Many to many relationships
          CarlSchwarz

          The answer is pretty simple, and you are on the right track but you don't need the extra dates table.

          Go to your "Project - Data Entry" Layout

          Change the portal to come from your "Project_Equipment_JoinTable" table (rather than the equipment table).  Don't change the table that the fields come from, leave them all as equipment::xxxx

          Just change the date field to "Project_Equipment_JoinTable::Date"

          and it all works fine.