mismatch
em, your base problem may be as simple as your data types are different. the first thing I would do to de-bug, is print-screen every table in design-view, and compare each field. I keep a "diary" as I build tables, so I can keep track of the field types and lengths.