6 Replies Latest reply on Dec 27, 2010 11:22 AM by philmodjunk

    Place saved finds on a layout

    projay

      Title

      Place saved finds on a layout

      Post

      Is their a way to put  saved finds(new feature with ver 10) on a layout?  I am using FM Pro 10 adv.

      Jay.

        • 1. Re: Place saved finds on a layout
          philmodjunk

          I assume you mean you want to see the list of currently saved finds on the layout instead of in a sub menu of the Records menu?

          Not as far as I know. But there are ways to save either the criteria used or a list of the found record's serial numbers in a table and then you can list those records on your layout or in a portal.

          If you have something different in mind, please elaborate.

          • 2. Re: Place saved finds on a layout
            projay


            "But there are ways to save either the criteria used or a list of the found record's serial numbers in a table and then you can list those records on your layout or in a portal."

            Basically I have about 3 customers that I do a lot of work for and would like to list them in a portal as you mentioned and be able to go and see there list of orders.

            • 3. Re: Place saved finds on a layout
              philmodjunk

              Define a table for listing any such customers. You may already have a table that lists all customers--including the three you wan to see in your portal. If you don't have a table, define one. If you have the second situation, add a field, Selected, to this table and format it with a single value check box so that you can designate specific customers to be listed in your portal.

              With either table, you should have at least two fields defined in your customers table, CustomerID--auto-entered serial number and CustomerName.

              You can use this relationship:

              YourTable::AnyField X Customer::CustomerID

              X is an operator to use in place of = when you want all records in one table to match to all records in the other.

              Now place a portal to Customer on your layout for YourTable. If you added the Selected box to an existing customer table, define a portal filter that only allows customer records with a value in the selected field to be displayed such as:

              Not IsEmpty ( Customer::Selected )

              Use a script similar to this to find your records:

              Set Variable [$CustID ; Customers::CustomerID ]
              Enter Find Mode [] // clear pause check box.
              Set field [YourTable::CustomerID ; $CustID ]
              Set Error Capture [on] //keeps dialog from interrupting script if no records are found
              Perform Find []

              You may need to modify this approach and the above script if the records in YourTable do not include a CustomerID field.

               

              • 4. Re: Place saved finds on a layout
                projay

                Thanks for the reply this is some good stuff.  So basically you would apply Not IsEmpty in the calculation area for this particular field...so that it only displays just those records.

                 

                • 5. Re: Place saved finds on a layout
                  philmodjunk

                  Not quite.

                  In Portal Setup (FileMaker 11 only)

                  Select the portal filter option and enter the expression there.

                  • 6. Re: Place saved finds on a layout
                    philmodjunk

                    Just noticed you said you were not using FileMaker 11Embarassed

                    Thus a calculation field could be used to match selected values as part of the relationship instead and you'll get the same result for FileMaker 10.

                    YourTable::cSelectedKey = Customer::Selected

                    cSelectedKey would be a calculation field that returns the same value as the single value in your Selected field's value list.