Advice Please - Simple

[Novice1]

Table 1: Contains two fields: (1) Abbreviated name of a unit; (2) Long name of a unit

Table 2: Contains a field with the long name of the unit

How do I change the long name field in Table 2 to reflect the abbreviated unit name?

Is this logical? Connect the tables (ID) then create a query?

 

[Ranman256]

Add Abrev field to table2
Make an update query
Join tbl1.long =tbl2.long
Set tbl2.abrev = tbl1.abrev

Remove tbl2.long field, if needed.

 

[Uncle Gizmo]

See YouTube Video:-
MS Access Update Query

 

[gemma-the-husky]

another way.

add a numeric field to table 1.
in table 2, store the numeric value.

then you can change the text values in table 1 without having to change things in table 2.

this is why surrogate keys (often autonumber keys) work so well