Hi, i was wondering if anyone could give me some advice. I’m currently in the process of entering data into my database and have one concern.
I have thousands of different companies to enter into my database and i haven’t checked the data for duplicates. I can’t do this before entering it so was wondering where i would start in stopping duplicate companies being entered in the database. Is there a way of stopping an INSERT if there is already a certain field in a table that contains the same data.
For example, say i had a company called Andrew and i tried entering another company with the same name. Also, how would i go about having a user friendly error that informs the person entering the data that it is already in the database and takes them back to the form to amend the data being inputted?
Does this make sense? If not i’ll try and make it clearer.