I need a program that will randomize the telephone field in my database. I need it to specifically randomize by using the last 4 digits of the telephone number. All telephone numbers are 10 digits? long. I have a database that will never change and it has an index key. When it randomizes? I need the index key to also be randomized. For instance:
Before Randomization
index? ? ? ? telephone
? ? 1? ? ? ? ? ? ? ? ? ? 5082736379
? ? 2? ? ? ? ? ? ? ? ? ? 5083948965
? ? 3? ? ? ? ? ? ? ? ? ? 5082952095
? ? ? 4? ? ? ? ? ? ? ? ? ? 5087788555
? ? ? 5? ? ? ? ? ? ? ? ? ? 5087758282
After Randomization
index? ? ? ? telephone
? ? 1? ? ? ? ? ? ? ? ? ? ? 5082952095
? ? 2? ? ? ? ? ? ? ? ? ? ? 5087788555
? ? 3? ? ? ? ? ? ? ? ? ? ? 5087758282
? ? ? 4? ? ? ? ? ? ? ? ? ? ? 5083948965
? ? ? 5? ? ? ? ? ? ? ? ? ? ? 5082736379
There are other fields in this database that need to be databound properly when it randomizes. I mention it, but I'm sure it's not a big issue. I assume it will happen automatically. I am attaching a database for you to use as a test.
## Deliverables
The program can be very simple. It should just have the ability to locate the database that needs to be randomized and then after selecting the path of the database the user can click a button that says "randomize database". After clicking this button, a progress bar would show the user that the program is actually working.