AnsweredAssumed Answered

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

Question asked by Handri on Mar 9, 2016

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

Outcomes