AnsweredAssumed Answered

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

Question asked by Handri on Mar 9, 2016
Latest reply on Mar 9, 2016 by beverly

This is the project I have now.

It is a Rental Shop.


I have tables as below :

1. Contact

2. Invoice

3.     InvoiceLineItem

4. Product

5.     ProductContact

6. Payment (to Contact who is supplier, not appear yet. )


Screen Shot 2016-03-09 at 5.21.18 PM.png


Story :

1. 80% of the Contacts are the Supplier for the Products . And the products has a margin to the Contact (suppliers)

2. Contact can rent their own product for Free, if their product appear on their Invoice.

3. The Rental Shop will generate a payment report to the Contacts (suppliers)


Question :

1. Do I need a dedicated Supplier Table for the Supplier instead of using occurance from the Contact ?

2. I am making a portal in the Layout (Contact) to display the products that they have in the rental shop. By using the data from the ProductContact, but it doesn't show up. How do I create the relation for this ?



Please advice


I am working on this project, if someone willing to help the project and teach me, I am willing to pay for that (not a big budget project), lets work together. Just PM me.