3 Replies Latest reply on Feb 28, 2013 8:14 PM by Lemmtech

    Sales Sheet Logic

    micheleclark

      Does it make sense that if I am making a small database for a salesman to record his sales, that each record should be defined by a different contact, and then on the bottom of each contact form, there be an ever changing portal of invoices for him to add to?

        • 1. Re: Sales Sheet Logic
          mikebeargie

          This is usually something we phrase to our clients in the form of a question.

           

          IE:

          "Will a sales order ever have more than one contact?" (many-to-many)

          "Does every sales order have only one contact?"

          "Will a contact ever have more than one order?". (one-to-many)

           

          Once that's answered, if there is a need for a one-to-many relationship (Contacts have MANY invoices), then we will establish that relationship between the two tables, and add the portal necessary to fulfill the "many".

          • 2. Re: Sales Sheet Logic
            ChristopherReesman

            I believe you are looking for something like this.

            E1.jpg

            The relationship looks like this.

             

            Here it is simplified.

            E2.jpg

            I hope this is helpful.

            Reesman

            • 3. Re: Sales Sheet Logic
              Lemmtech

              Why not have an Invoices or Sales area and just have a field that salesman that just populates with his name. sure you can have a portal of sales but this should just take you to a seprate invoice screen to create the sales of the products.