1 Reply Latest reply on Dec 11, 2012 9:30 AM by philmodjunk

    How to generate a new CompanyID for new Company ?

    wimrippen

      Title

      How to generate a new CompanyID for new Company ?

      Post

           I work with FM12 pro adv/ and FMServer12 adv. and Win 7

           How to generate a new CompanyID for new Company ?

           I am building a database with old CompanyID from imported Database ex ACT2011 ,but

           if I add a new Company in FM  I like to generate a CompanyID, which is SAME  as related Contact,if new Contactname of that Company.

           How ? with UUID for the empty CompanyID field ?

           Thanks for the help.

           William

            

            

            

            

        • 1. Re: How to generate a new CompanyID for new Company ?
          philmodjunk

               The simplest is to set up CompanyID to auto-enter a serial number, but you can also use an auto-entered calculation Get ( UUID ) to auto-ener a "universalUniqueIdentifier".

               But neither option assigns a value to existing records. You can use Replace Field Contents from the records menu to update the CompanyID field with either serial numbers of UUID's.