AnsweredAssumed Answered

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

Question asked by Handri on Mar 9, 2016



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,