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

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

    Handri

      bigtomChrisJohnstonkeywords

       

      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.

       

      http://www.filedropper.com/invoicetestfmp12

       

      Please Advice.

       

       

      Thank you,

       

       

      Handri