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.
The Cherokee is the most southern branch of the Iroquoian language family. Linguists believe that the Cherokee migrated from the Great Lakes area to the Southeast over three thousand years ago. In 1540 the Cherokee lay claim to a territory comprising of 40,000 square miles in the southeastern part of what later became the United States. This area included parts of the states of Alabama, Georgia, North Carolina, South Carolina, Virginia, West Virginia, Kentucky and Tennessee.