4 Replies Latest reply on Dec 28, 2010 3:14 PM by projay

    Balance Due Field Placement

    projay

      Title

      Balance Due Field Placement

      Post

      Which table should I place a balance due field....[Customer] or [Invoice]?

      Jay.

        • 1. Re: Balance Due Field Placement
          philmodjunk

          Depends on how you want to calculate the balance due.

          If this is the balance due for all invoices for a given customer, put it in Customer.

          If this is a balance due for a given invoice, put it in Invoice.

          • 2. Re: Balance Due Field Placement
            projay

            Makes sense. 

            So basically I gather that you can do all sorts of self-join and create portals to receive different types of data.

            Is their any limits to a number of self-joins a table can have?

            • 3. Re: Balance Due Field Placement
              philmodjunk

              Eventually, you can run out of space to place additional Table occurrence boxes, but you have to work at it. Keep in mind that you also have summary fields which can compute multiple record totals without using a relationship at all.

              • 4. Re: Balance Due Field Placement
                projay

                Thats what I did is us a summary field for my balance due.

                My thoughts on the table occurrences was not related to the balance due field....just in general for other reasons...

                So basically, you can create table occurences as many times as you like until you run out of space(not saying that i have that much of a need to do that).

                I was just getting some idea on table occurrences...before i started creating them...don't want to jack anything up.