Thanks, and yes if it were up to me I would make the datatypes consistent across tables. Unfortunately I'm neither the DBA, nor programmer. .I'm the QA guy that...

.. it turns out that wasn't the issue, it had to do with the triggers on the tables and modifying fields within the primary key on that table.

On the...