Testing to See if a Record has Been Inserted?

I'm trying to perform a check on a table to see if a record has been inserted yet, however using the test on the insert command is not appropriate because I'm ending up with duplicate entries!

If more than one duplicate record is found it is to error as an invalid entry.

Any help is much appreicated, thanks!