5 Replies Latest reply on Jan 29, 2009 8:22 AM by TSGal

    Split table view, like Excel

    Ayla

      Title

      Split table view, like Excel

      Post

      Hi

       

      I am viewing my database in Browse Mode and Table View.

       

      I would like to split the view (columns) vertically like you can do in Excel.

       

      So that when I use the bottom scrollbar, it only scrolls, for example, the right side of the view and the left stays still.

       

      How do I do this in FileMaker Pro (10)?

        • 1. Re: Split table view, like Excel
          davidanders
            

          You can not do this in Filemaker.

          You can have two or more windows open, viewing a table in different ways.

          • 2. Re: Split table view, like Excel
            Ayla
              

            Thanks for the reply!

             

            "You can have two or more windows open, viewing a table in different ways."

             

            How do I do that, then?

             

            Thanks

            Martin 

            • 3. Re: Split table view, like Excel
              davidanders
                

               In FMP7,8,9,10...

              Under the WINDOW Menu, choose New Window.

              • 4. Re: Split table view, like Excel
                Ayla
                  

                OK, thanks, and I can edit/write in both windows as much as I want, switching back and forth and the database keeps track of it all, without problems?

                 

                PS. what if I want it to remember the window settings, after quit'ing the program, can I save a kind of "windows set" or similar?

                • 5. Re: Split table view, like Excel
                  TSGal

                  Ayla:

                   

                  Thank you for your post.

                   

                  Yes, you can switch back and forth between the windows without any problems.

                   

                  If you want to remember the window settings, you will need to create a script for each window.  Then, at the end of your first script, put in a "New Window" script step followed by a Perform Script externally in the second Window.

                   

                  For example, your first window has a particular layout and found set.  The script may look like:

                   

                  Go to Layout [ <first layout> ]

                  Perform Find [Restore]

                   

                  In your second window, you may be in another layout and be in Table View.  The script may look like:

                   

                  Go to Layout [ <second layout> ]

                  View as [View as Table]

                   

                  Now, return to the first script and change it to as follows:

                   

                   

                  Go to Layout [ <first layout> ]

                  Perform Find [Restore]

                  New Window ["Table2"]
                  Perform Script [External: "Table2"; <second script name> ]
                   
                  Let me know if you need clarification for any of the above steps.
                   
                  TSGal
                  FileMaker, Inc.