if you have referential integrity turned on in the relationship

you won't be able to change the data type

cos you can only join like for like with it turned on

(ie number to autonumber and text to text)

Posted By: blindasabat, Sep 25, 13:30:13