Attach and update records automatically

I have three objects in the app :

Users object,

Premises object,

Codes Object.

The Users' object connects to Premise object with a many to many relationship.

The Premise object connects to Code object with a many to many relationship.

We create Premises and we attach Codes to them.

Then we create Users and attach Premises to them.


I am trying to find a way to attach and update Codes to Users automatically.

I tried to do that with combination of triggers but with no luck so far.


Any ideas would be very much appreciated.

Thank you in advance.

Continue reading...