AnsweredAssumed Answered

Assignments Not working

Question asked by dig on Sep 3, 2016
Latest reply on Sep 3, 2016 by 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.



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.