AnsweredAssumed Answered

Prevent duplicate Ids being created in join table portal

Question asked by KylerPhilips on Apr 17, 2015
Latest reply on Apr 21, 2015 by KylerPhilips

Title

Prevent duplicate Ids being created in join table portal

Post

Hello, 

I have a button which allows a portal with customers to be clicked on a relevant record and then the script (attached image) adds it into my ClientEquipmentJoin table and associates a client with an item. In short two portals - the client portal allowing the creation of records within the equipment join table. How can I prevent duplicate __pkClientIds being created in the join table that I have? 

Tables: Clients, Equipment, ClientEquipmentJoinTable

Maybe a dialog box that pops up saying you've already added this client to the item join table. 

Thanks

 

 

 

 

script.JPG

Outcomes