Solved changing a field in a database?

January 25, 2013 at 04:11:11
Specs: Windows 7
Can a 'text' field in a database be changed to an 'auto' field - for instance when creating a new report a new reference number must be entered into the field which already has in the drop-down menu a list of previous numbers used which must not be used more than once! We were looking to change this so that the next reference number would be populated automatically to avoid reuse of a prev number?

See More: changing a field in a database?

Report •

January 25, 2013 at 09:21:47
✔ Best Answer
The most generic way to do this would just be to create a duplicate table (with the appropriate modification) and copy the data across. Then delete the old table and rename the new one.

Of course it may be that there is an easier solution with the database software that you are using. But as that is a mystery to us we can't help there.

Report •
Related Solutions

Ask Question