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.
Tribal Government. The Cherokee Nation operates under a three-part government including the judicial, executive and legislative branches. A revised constitution of the Cherokee Nation was ratified by the Cherokee people in June of 1976 and approved by the Commissioner of Indian Affairs on September 5, 1976. In 1999, a Constitutional Convention convened to review and update the Cherokee Nation's Constitution.