5 Replies Latest reply on Mar 17, 2016 4:41 AM by rjames_tablet

    Find specific values

    rjames_tablet

      Please see attached I have created.

       

      When I click on the find button and select 'period 1' it shows as expected client 2

      1.JPG

       

      What I would like to have if possible is for the find to show only the line that relates to 'period 1' eg

      2.JPG

      I think I will probably need to re work it altogether but if someone could just point me in the right direction, that would be great

       

      Thanks

        • 1. Re: Find specific values
          dtcgnet

          You could filter the portal for the client to show only the records that match the period you were trying to "find". On the other hand, it would be good to know more about what you're trying to accomplish.

          • 2. Re: Find specific values
            fitch

            You could add a Filter to your portal:

            related::Period = FindField

            • 3. Re: Find specific values
              beverly

              I agree. Don't "Find", just "Filter"!

              beverly

              • 4. Re: Find specific values
                brianc

                I have modified your file to make this work.

                 

                I added a KP (Key Primary) field to the Primary (Parent) table

                I created a child table that contains the Issue Date, Total and Period.

                I added a KF (Key Foreign) field to the child table.

                I went to the Relationship Graph and made a link between these two fields and set the relationship to allow creation and deletion of related records in the child table.

                I assigned serial numbers to the KP field in the parent table.

                I imported the data in two passes to the child table for the Issue Date, Total and Period.

                I then created a tab object with 2 tabs and 2 portals on the main screen that both pointed to the child table.

                I set the object names up on each of the 2 tabs so that I could use Go To Object [] in the Find script

                One of the portals I set up with a filter so that it would only display the data in the portal if it matched the data stored in the FIND field.

                I modified the find script to work with the new child table and made sure that it redirected the user to the correct tab to show the filtered portal instead of showing all of the related records.

                I added a reset button for the Find and a script to handle the reset.

                I changed the tables that the other layouts were linked with from the parent table to the child table and fixed the fields.

                 

                This should give you what you are looking for.

                https://dl.dropboxusercontent.com/u/18365301/test%20unsold%20Copy%201.fmp12.zip

                • 5. Re: Find specific values
                  rjames_tablet

                  Wow thats great. As others have 'filter' is the way forward, I didnt know that

                   

                  Many thanks