Ratslinger, thanks for the response.
I am running LO 22.214.171.124 on a windows 7 SP 1, 64 bit box and I am using LibreOffice Base as the database.
i understand why some disagree with using a Varchar column as a PK yet as I mentioned I want to relate the column to another table where it will there be a FK . And to make that relation to a FK it seems that LO Base about insists the column in the first table to be a FK to properly relate. And the reason I have it as a varchar is because the column has both alpha and numeric values.
I did find the problem. In Calc, before cutting and pasting I had performed a duplicate check function and had no duplicates with that function. I found a different function to check for duplicates and this new function did find one duplicate so that was my problem.
So my problem was not the inport into Base it was a faulty duplicate check in Calc.