|
Hi All,
I am creating a databse of articles and related information. I need to find a way to prevent the user from inputting duplicate information in a few forms.
In one of these forms I can just set my table not to accept duplicate values (Journal Title) because no two journals will have the same name.
In another, I am working with author information. I think to allow only unique records i will need to check last name, first name, middle name(s) and maybe one other field. More than one individual may have the same first last and middle name but would have (most likely) a different affiliation or other piece of information that distinguishes a duplication vs a similar entity.
In my final table (this is the most important to not have duplicate records) I have all info about an article. I think the best way to avoid duplicates is that no two articles can take up the same space in the same publication. So I have, 3 fields (at minimum) that distinguish one article for another
Journal Title, Volume, and Page Range.
My question is this, how can I prohibit the entry of duplicates by comparing the contents of all three fields to the rest of the records in my table. And then have a message pop up letting the user know that they've tried to enter in duplicate information, that sends them to the pre-existing record upon "okay".
Thanks!
[email removed]
| 
