Rename Values in One Table and Update in Other Tables

[severitt]

I am a new Access user. I have a field in one table labled DocID that I need to rename the values contained in that field. Once the values in this field are renamed, how do I update the values of this field in a seperate table automatically? Can someone please give me step by step instructions.

[NeoPa]

I am a new Access user. I have a field in one table labled DocID that I need to rename the values contained in that field. Once the values in this field are renamed, how do I update the values of this field in a seperate table automatically? Can someone please give me step by step instructions.

What do you mean by 'Rename the values'?
Do you want to give the field a new name, or do you want to change the contents of the field?
If you want to change the contents - what do you want to change them all to?
Do you want changes made to the values of one field in this table to be reflected on a linked field in a separate table?
If so you need to set up a relationship between the tables.

[MMcCarthy]

I am a new Access user. I have a field in one table labled DocID that I need to rename the values contained in that field. Once the values in this field are renamed, how do I update the values of this field in a seperate table automatically? Can someone please give me step by step instructions.

As NeoPa says ...

If DocID is the primary key of one table and the foreign key of another table then you can change the values in the table where it is a foreign key without any problems. However, if you are trying to change the values in the table where it is a primary key this is a lot more complicated. You will need to post a full list of the fields in both tables and explain what you are trying to do and why as it will affect how we answer.

[PEB]

Maybe you want to change your fields using a Criteria?
And just update in separate table... Maybe you want them to separate table? If you want to Update them so the suggestion of NeoPa is very good for thr primary and Foreign keys!