2 Replies Latest reply on Aug 27, 2014 12:54 PM by sergeDecelles

    Find request

    sergeDecelles

      Title

      Find request

      Post

           I have a Parent table named Customers and a Child table named Invoices.

            

           How can I perform a find on the Parent table that only shows the customers that have at least one invoice?

            

           Can this be alternatively be done via relationship and TO  instead of performing a find request?

            

        • 1. Re: Find request
          philmodjunk

               And there is a relationship linking Customers to Invoices?

               If such a relationship exists:

               Customers::__pkCustomerID = Invoices::_fkCustomerID

               Then you can put the Invoices::_fkCustomerID on your Customer layout, enter find mode and specify a lone * in the _fkCustomerID field.

               Can this be alternatively be done via relationship and TO  instead of performing a find request?

               Go to the Invoices layout.

               Show all records.

               Use Go to Related records with the "Show only related records" and "match found set" options specified to pull up all related records in Customers.

          • 2. Re: Find request
            sergeDecelles

                 Thank you.

                 I will test these 2 ways of doing it.