Using MS Access 2002 SQL ...
I want to update the values of a field in table one, a text field with numeric values to their respective text equivilent located in another table (two) which consists of 2 fields, the text equivilent and its numberic id number. Each time I attempt using an update SQL, I get one error or another. The following is an example as I need to do many of these.
UPDATE [Future Homes] INNER JOIN playuda
ON [Future Homes].FUTURE_HOME_ID = playuda.FFHome
SET playuda.FFHome = [future homes].[future_home_name]
WHERE (((playuda.FFHome)=[future homes].[future_home_id]));
playuda.ffhome is a numeric value (text field)
future homes.future_home_id is a numeric value (text field)
future homes.future_home_name is a text value (text field)