Auto populating a column with unique values from another table
I have two tables. In Table 1, I have over 10,000 records. Each record has a value for the field "Country." In Table 2, I have a field named "Country," which I would like to autopopulate with a record for each unique value of country from Table 1.
Basically, I want to select the unique values from Table 1 and insert the unique values in Table 2.