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.
Cherokee Indians. The Cherokee Indians were one of the largest of five Native American tribes who settled in the American Southeast portion of the country. The tribe came from Iroquoian descent. They had originally been from the Great Lakes region of the country, but eventually settled closer to the east coast.