1 Reply Latest reply on Sep 29, 2010 9:36 AM by philmodjunk

    Auto enter



      Auto enter


      Their a way to auto enter last four digits of Social Security Number? In employee profile their a way to to have it auto assign last four of Social as employee id?

        • 1. Re: Auto enter

          Do you have the full serial number already entered in another field?

          If so Right ( SerialNumberField ; 4 ) will do that for you, but be advised that the last 4 digits won't be unique (even the full SSN isn't always unique in every situation due to immigration fraud and clerical errors.) Thus, you should have an Auto-entered serial number to use as your PrimaryKey and only use this field as a way to quickly find records.