I have a simple script I’m trying to write, but since I’m new it’s not simple to me… LOL
I have a junction table I’d like to automatically populate. In this example…
I want to connect every bug with every home. So anytime a bug is added to the Bug Table, the junction table is updated to connect it with every home.
Likewise, whenever a Home is created, the junction table is updated with every bug.
Lastly, I want the script to clear any junction records if either a bug or home is deleted.
I started with the script from this thread HERE, but just couldn’t figure out how to modify it to make it work.
Lollipops for anyone who can help me! Thanks.