[AccessD] Convert text to number X posted

Finally found big trap in inherited database.

 

Foreign Key Vendor ID is set as text. I need to convert it to long number. 

 

If I change data type to number Access threatens to delete all fields.

 

I cannot find anything in help on Cnum.

 

All thoughts apreciated

 

JOE HECHT

LOS ANGELES CA 

jmhla at earthlink.net