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.
Our Government. The Cherokee Nation is the federally-recognized government of the Cherokee people and as such has sovereign status granted by treaty and law. Its capitol is the W.W. Keeler Complex near Tahlequah, Oklahoma the capital of the Cherokee Nation. Cherokee Nation has operated under a constitutional form of government since 1827. Today there are more than 320,000 registered Cherokee citizens, making us the largest Native American tribe in the United States. The modern Constitution of the Cherokee Nation was approved by the Commissioner of Indian Affairs on Sept. 5, 1975, and ratified by the Cherokee people on June 26, 1976.