3 Replies Latest reply on Jan 5, 2009 1:09 PM by TSGal

    Show all Records

    milky

      Title

      Show all Records

      Post

      Hi All,

       

      I have succesfully constructed an Invoice (with much help from this forum) and now would like to show a list of all invoices on another layout in a portal

      (I assume).

       

      The following fields are required:

      Invoice::InvoiceDate

      Invoice::InvoiceID

      Invoice::IDWedding

      Invoice::FullNameAndAddressResult

      Invoice::InvoiceTotal

      Invoice::PaidAll

      Invoice::BalanceOutstanding

       

      I dragged a portal onto a new layout (with show records from Invoice layout) and then dragged the above fields onto the portal, but nothing gets populated.

       

      What am I doing wrong?

       

      Any help would be greatly appreciated.

       

      Milton.

        • 1. Re: Show all Records
          davidanders
            

          You created a new layout in what Table?

          What is the relationship of that table to Invoice?

          List of all invoices in relation to what?

          • 2. Re: Show all Records
            milky
              

            The layout was based on the Invoice table.

            No relationship as its in the invoice table,

            I want to show a list of all invoices as if it were an excel spreadsheet style.

             

            thanks again.

             

            Milton.

            • 3. Re: Show all Records
              TSGal

              Milton:

               

              Thank you for your post.

               

              If there is no relationship, then nothing will appear in the portal.

               

              If you want to show your invoices in a spreadsheet style, then go to a Layout that shows your Invoice table, and then pull down the View menu and select "View as Table".

               

              TSGal

              FileMaker, Inc.