3 Replies Latest reply on Oct 5, 2009 9:39 AM by Marky1

    Filtered Value Lists With No Input



      Filtered Value Lists With No Input


      Hi all,


      Just wondering if there are any techniques for achieving the following example:

      A company pop-up filters a second contacts pop-up (this is done)

      but when the company pop-up is empty the contacts pop-up should show all contacts (at the moment no match is found so it displays nothing)





      PS: im on FMPA 10 on a mac 

        • 1. Re: Filtered Value Lists With No Input

          One way would be to create two calcs. On the parent side you can have a calc which will return something when the other field is empty.

          Case ( IsEmpty ( Field1 ); "All"; Field1 )



          Then on the child side, you would have another calc with your current key field concatenated in multi-line with the string "All".


          List ( ChildsideCompany; "All" )



          I wasnt sure if you were using IDs to match or not so I just left the name as a generic ChildsideCompany for this example.


          Now change your filtered relationship to be based off those 2 new calc field.

          • 2. Re: Filtered Value Lists With No Input

            Hi there,


            I now have a calculated field on the contacts side with



            (1 being the ID) 

            and the calculated field on the other side is being updated with "All" fine. But when it is set to "All" it still cannot find anything..

            do I need to tell filemaker to look on the second line aswell?

            Sorry if this isn't very clear,



            • 3. Re: Filtered Value Lists With No Input

              Sorry, Had my calculation result as a number - that ALWAYS gets me muddled.


              Thanks for your help!