Prevent duplicate Ids being created in join table portal
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.