Hi...



I am trying to create an append query, and have come up with an error "An INSERT INTO query cannot contain a multi-valued field." I have followed instructions provided by MS, and have been searching for a solution with no luck.
I have three different tables that need to be archived (Student Information, School Background, Grades) each year... All three tables use at least one LookUp field. I have read that LookUp fields are not the best to use, but I don't think I can do without them for these tables. Is there any way around this error?

Thanks..!