8 Replies Latest reply on Mar 9, 2016 7:49 AM by beverly

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

    Handri

      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.

       

       

       

      Regards,

       

       

      Handri