Hi all,
i've got a many to many relationship between my property and project. I've created the link table and the portal is showing the records that I want.
I need to be able to assign more than one project to a property. What is the best way of doing this. I created a global table and a global field so I can set that and then use a script to update the link table. However, I@m not sure my relationship is good as I can't seem to get my global field to populate.
Is there a better way of allowing this? Potentially I need to be able to assign up to 10 projects to a property.