By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Rename Values in One Table and Update in Other Tables

P: 1
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.
Nov 14 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,494
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.
Nov 14 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Nov 15 '06 #3

PEB
Expert 100+
P: 1,418
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!
Nov 18 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.