Unwanted creation of Record in Related table
I'm new to creating databases and am in the process of creating a database to handle all my photos and the sales of them. I am having an issue with creating related tables. I have a number of tables in the database and most of the relationships that I have created seem to be working okay but there is one troublesome one! I am importing information from another table and the information is appearing as i would like. 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. As I said i am new to this and I hope I have explained it well enough. Any help would be very much appreciated!!