You said, "The issue is that a new record is created in the original table with the primary key data entered. As you can imagine, I don't want that record to be created."
This statement has me confused. If you don't want a new record created, how is it being created? Through the import? Manually? Is it the primary key entered that is troublesome?
Can you please explain in greater detail? That is, what is happening, should it be happening, what result would you like to see, and what were you expecting to see? This may help me understand the problem a bit more.
Many thanks for your response. I think I have figured out what the problem was. I think it was because I had entered the primary key field from the original table in the current table instead of using the foreign key (the primary key was set up to automatically generate a new serial number. I have since made the primary key none-changeable). If I made a search using the then primary key field it was generating a new record in the original table . Now I have replaced with the foreign key the issue seems to have been resolved. I realise now that my original post was rather vague. Hopefully next time I will have a bit more knowledge so that I can make myself clearer.