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?
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.
Retrieving data ...