Is the name field a field of type text, type number or a calculation field that combines first and last names? If a calculation field, is text selected as the result type?
Sorry for wasting your time on this. The solution in question uses ODBC to refresh its data on a daily basis for some internal reporting that we did. The import script for this table was not working and the Customer table had not been populated.