I was asked to look at somebody elses Access 2002 DB with a request to change a field "Req Nbr" which is an auto-number field to a non-autonumber field so the user can fill in their own values. Also the field is a Key field used to link to another table.
Can I change the field type to just number? When I attempt it says I can't change it without dropping the link. Could I drop th link, change it and then relink it?
Can I change the field type to just number? When I attempt it says I can't change it without dropping the link. Could I drop th link, change it and then relink it?