4 Replies Latest reply on Sep 3, 2016 1:52 PM by dig

    Assignments Not working

    dig

      Hello All – I need some assistance please.

       

      I don’t understand how to stop this from happening, I am hoping someone can show me why this is happening.

       

      I have attached my latest working file.

       

      PROBLEM: Whenever I assign a piece of plant to a job site via the DIESELS_PLANT Layout, the Site assignment does not stay and changes to the last site I assigned them; the plant however remains as set for that particular customer.

       

      I have two Customers, Four piece of plant and four job sites in my example.

       

      I used a join table as many customers have many sites and many sites can be related to many customers.

       

      I have assigned Sites to customers, I have assigned Plant to customers. No Problem.

       

      What I would like to see via a portal on the Customers layout is what plant they have assigned, what site it is at and who the contact is.

       

      Matrix:

      Site 1 = Plant 4 for customer Marvin the Martian

      Site 2 = Plant 3 for customer Michigan J. Frog Inc.

      Site 3 = Plant 2 for customer Marvin the Martian

      Site 4 = Plant 1 for customer Michigan J. Frog Inc.

       

      NOTE: I am unsure if this is bad practice or simply unnecessary but I serialized the _kf fields in the join table.

       

      Thanks

       

      Troy

       

      Error.JPG