4 Replies Latest reply on Jun 22, 2009 10:22 AM by philmodjunk

    Adding the same info for all records

    IanT

      Title

      Adding the same info for all records

      Post

      Hi

       

      Can anyone help?  I have 941 records in my database and before merging it with another one I'd like to put the same info in one of the fields for all records to identify them as having come from the same database.

       

      Is there a way of doing it in one go rather than manually entering 'OD' into the same field for each record.

       

      Thanks a lot for your help.

       

      Ian 

        • 1. Re: Adding the same info for all records
          LaRetta_1
             You don't indicate exactly how you plan to 'merge' the two files.  But you can use a global field and type data into it.  This data will be the same for ALL records.  Globals are specific to the User and are only session-specific so, if you close the file (when being served), you will lose the global value. 
          • 2. Re: Adding the same info for all records
            philmodjunk
              

            If you do need your value stored in a local field, if you have a calculation that refers to it and it needs to be a stored, indexed field for example, you can use Replace Field Contents.

             

            This is a powerful tool, so look it up in help and experiment with a copy of your file until you are confident you've got it to work for you. I would also avoid using this tool on the file while it is being shared over a network unless I was absolutely sure that no other users might be editing one of the records as that will mess up your use of this tool by keeping one or more records from being updated.

            • 3. Re: Adding the same info for all records
              IanT
                

              Thanks a lot - it worked. By merging I meant I will then export that whole file into another existing file.

               

              You may also knoe the answer to this:

               

              Can I do a search for all records that contain 'x' in a specified field and replace 'x' with 'y' in the same field in that found set?

               

              Regards

               

              Ian 

              • 4. Re: Adding the same info for all records
                philmodjunk
                   Same problem, same trick really. You may have to specify a calculation depending on what is in the field where you change 'x' to 'y' in your Replace Field Contents operation.