AnsweredAssumed Answered

Preventing Duplicate Portal Row records automatically

Question asked by LiamNeville on Mar 21, 2013
Latest reply on Mar 21, 2013 by LiamNeville

Title

Preventing Duplicate Portal Row records automatically

Post

     Hey guys,

     New to Filemaker, and enjoying it as frustrating as it can be.

     I have a database for a media company where you add crew to a shot you are working on. I have a set up some checkboxes and radio buttons that can automatically add crew into a portal row. For a simple example...

     checking '3D Animation' will add the crew members '3D Animator' & '3D Lighter'.

     checking '3D Object' will add the crew members '3D Lighter' & '3D Modeler'

     It is possible that a scene will have both  '3D Animation' &  '3D Object', but i don't want '3D Lighter' to be added twice.

     I have gotten it to remove the duplicate portal row using a self join relationship and a validate property, using the principles here (http://help.filemaker.com/app/answers/detail/a_id/6186). But the problem is that it only removes the portal row after validation. (which i sped up using a on modify commit record script trigger on the portal pow).

     I've also tried this technique without 100% success (http://help.filemaker.com/app/answers/detail/a_id/6186)

     What would be ideal is if i can get the portal to check other rows and not add the other crew member at all, avoiding dialog boxes, and validation.

      

     Any ideas would be greatly appreciated.

     Cheers

Outcomes