2 Replies Latest reply on Mar 14, 2014 2:46 AM by joaocoutinho

    Copy Paste Search

    joaocoutinho

      Title

      Copy Paste Search

      Post

           Hello Everyone,

           Sometimes I receive an email from my coworkers to make some adjustments to records on our database like this:

           

                Please close this records:

           

                264

           

                325

           

                254

           

                326

           

                321

           

                323

            

           Is there any way to copy this text an past it on ID field and make the search? Any custom function for this? 

           Thanks in advanced for your support.

           Best regards,
           Joao Coutinho

        • 1. Re: Copy Paste Search
          philmodjunk

               If those are ID's (Primary Keys), you don't need any function, just a relationship.

               Say you set up this relationship:

               SomeTable::GlobalTextField = YourTable::PrimaryKey

               If you paste this list of ID's into GlobalTextField, a portal to YourTable will list all of the records for which you just pasted those IDs. Then a button in the portal row can be clicked to use Go To Related Records to bring up that record.

          • 2. Re: Copy Paste Search
            joaocoutinho

                 Phil,

                 Really simple soluction :) I will implement that.

                 Many thanks!

                 João