renaming a filed in a table (1 Viewer)

[adil_karampurwa]

I have a table Client-Details,in which i have a record namely "bharti-chennai".this table is associated with aother table "release-details". bharti-chennai has records in relase details.i want to change the name of bharti-chennai to bharti -mumbai ..how to do it.

 

[statsman]

Open the table that contains the field and change the name.

Now comes the fun part. The name change should be reflected in all of your queries, forms, macros and reports, but it may not be. You have to go through each one and ensure the name change has taken place and if not, change it manually.

Are you certain this name change is essential?

 

[Bat17]

this is why it is best to use ID's to join tables. Done that way the name is only a lookup and can be changed easily
if you have set referential integrity you can use it to cascade updates.

Peter