0 Replies Latest reply on Mar 9, 2016 6:40 AM by Handri

    Select Record from Portal, Not Duplicated Supplier Products, Flagging as Supplier




      As I have get the last problem solve as below

      Contact and Supplier Table ? Do I need 2 tables ? 80% Contact is Supplier


      I decided to make a Status from the Contact table to show whether the contact is a Supplier(1) or Not Supplier(0) by using Number.

      The process is when I adding Supplier in the Products, it trigger a script to set this field to 1 or 0.


      1. Is these Number type of field is the best to flag the Contact whether they are Supplier or Not Supplier ? or using text is better?


      2. I made the portal in the product layout to select the contact as the supplier. I set it x to the relation between product with ContactMatchID. So it will show up all the Contacts as a list in the portal. I can select 2 times or more for the same contact. How can I avoid this ?


      3. The relation between Supplier (in this case Occurrence of the Contact) is many to many with Products. So I think my script won't work, if I delete it from portal, the script will trigger the Status in the Contact table to "0" even, the Contact might have other Products they owned. How can I solve this ?



      Here is the file.




      Please Advice.



      Thank you,