With this information we can help you set up a form/subform scenario and/or table/query to feed the from/subform. As for your error message... You cannot relate fields from different tables that are not of the same Data Type.eeHaaaaa! I created a Query for the two tables and based the Form off of the Query. This enters data into both tables as needed. I also discovered that a Macro can help me AutoEnter the necessary data based on the City, I'm just trying to get it to recognize the 27 cities and match data accordingly.
Cherokee Indians. A powerful detached tribe of the Iroquoian family, formerly holding the whole mountain region of the south Alleghenies, in southwest Virginia, western North Carolina and South Carolina, north Georgia, east Tennessee, and northeast Alabama, and claiming even to the Ohio River.
Current Status. 1  Active-The Eastern Band in North Carolina and the Cherokee Nation in Oklahoma are officially recognized by the United States Government. 2  Eastern Cherokee, Southern Iroquios, and United Tribes of South Carolina were recognized in 2005 as a group by the state of South Carolina. They are now known as the Eastern Band of Cherokees. 2  Today the Cherokee are presently the largest tribe of Native Americans in the United States. 3  They boast large and prosperous reservations in Oklahoma and North Carolina, and there are smaller groups of Cherokee in Alabama, Arkansas, Georgia, South Carolina, and Texas.