3 Replies Latest reply on Dec 30, 2013 12:07 PM by deninger

    Table View sorting and Value Lists

    kaostika

      Hi, I made a single table for all my value lists so the client can add things as they wish. But in table view when they sort, blank records appear at the top. Is there a work around for this. I want to make use of the table view built in functions as much as possible,

       

      Oreste

        • 1. Re: Table View sorting and Value Lists
          deninger

          Just guessing here, but blank records are likely "new" records that never received values. You need to either test for this (validation before commit) or periodically delete these with a script (maybe a script trigger opon opening of the layout).

          • 2. Re: Table View sorting and Value Lists
            kaostika

            The value list table has multiple fields the will be used in pop up fields.  So it may have 10 values in one and then 20 in another.  So there will be a lot of blanks.  I use the table since it is really cheap interms of Development Time to use

            • 3. Re: Table View sorting and Value Lists
              deninger

              Okay, I see now.

               

              While there are a number of ways to attack this, it might be easiest to have a second field in your table that describes the list. For example:

               

              Field 1 = List Name , Field 2 = List Value

              Presidents , George Washington

              Presidents , John Adams

              ...

              States , Alabama

              States , Alaska

              ...

               

              Now define a relationship that limits the records (Table1.List Name = Table2.listName where you could have "Presidents" or "States" in the related field. Now, from within the inspector, create a list that populates from a table showing only related records based on Table1.