Change field to lookup without losing info???

[bgibsonIYD]

3 Tables: Names2, State, Country

Names2 has a State and Country Field that need to be lookup fields to lookup the state abbreviation and the country abbreviations

State: StateID,Abbreviation,STATE
Country: CountryID,Abbreviation,COUNTRY

The Names2 table already has 4800+ records. How do I change the State and Country fields in Names2 without losing all the data that already exists for those 4800+ records? Beth
**Learning Access**

 

[thebernieb]

Beth,

Are you trying to make the state and count fields lookup boxes? If that is the case, you won't lose any information so long as you have the same values in the look up tables for State and Country.

If you are just trying to change the values for the 4800 records, that can be accomplished with a little VB code. Let me know if you need something like that. I'm not exactly sure if I understand what you are trying to accomplish.

Bernie

 

[LDeMaio]

Beth,
If I understand your question, you can just change the field names with no problem. The lookups will still remain with those fields no matter their names. Make a copy of the table and test it.

If you want, you can create a copy of the table, delete all the records in the original, change the field names and append the records back from the copy.

The first suggestion will work with no problem

Larry
SDC