autonumber->number of key

[interuser]

Hi I have a table STUDENTS with key (autonumber) StudentId.
Studentid is a lookup column in other tables and forms
I want to make it number. When I try, I get "you can't change the data
type or field size of this field; it is part of one or more
relationships"
A way I thought of to bypass this is :
1. delete the table and thus all the relationships
2. paste the table from a backup of the .mdb I have
3. change the type

Now there are 2 issues:
A. I think the relationships do not hold anymore. I infer that because
if i try to delete the table once more, it does not tell me that its
relationships will be deleted.

B. Also, if I rename the table, it is not renamed in all queries, and
lookup columns it is used.

About B, I thought to open all queries and tables and just save them so
that "auto-rename" will work when I want to rename the table.

I thought to do the same for A, but the relationships are still not
recreated (because if I try to delete the table I get no warning).

To cut the long story short, is there a way to make this field from
autonumber->number and retain all relationships and the "auto-rename"
feature ?

[Darryl Kerkeslager]

"interuser" <in*******@hotmail.com> wrote

Hi I have a table STUDENTS with key (autonumber) StudentId.
Studentid is a lookup column in other tables and forms
I want to make it number. When I try, I get "you can't change the data
type or field size of this field; it is part of one or more
relationships" [snip] Now there are 2 issues:
A. I think the relationships do not hold anymore. I infer that because
if i try to delete the table once more, it does not tell me that its
relationships will be deleted.

B. Also, if I rename the table, it is not renamed in all queries, and
lookup columns it is used. [cutting long story short] To cut the long story short, is there a way to make this field from
autonumber->number and retain all relationships and the "auto-rename"
feature ?

It sounds like you have deliberately or accidentally deleted some but not
all of the relationships that table STUDENTS participates in.

1. In the Relationships Window, go through the entire list of tables and
show all of them. Make sure you don't miss any.

2. Delete any relationships to table STUDENTS.

3. Change the field type from number to Long

4. Reconnect the relationships.
Darryl Kerkeslager