Hi,
I'm pretty new to Access and I've created a table and a bunch of forms and everything is working good. My problem is that I want to avoid entering duplicate items based on 3 fields and can't figure out how to get it done. I read something about indexing, but tbh (like I said) I'm a total noob at this and have no idea what to do. Any help would be greatly appreciated.
I dont know what I should post here for anyone to be able to look and and maybe help me out, but I'm using Aceess 2007, my only table (which all of my forms, queries and report work off of) is MainInventory. The 3 fields that need to be checked for duplicates are Item, PN and Version (but version doesn't always apply and is sometimes a blank field).
For example:
Item = Filter
PN = 3665
version = A
or
Item = Bracket
PN = 45589
version = (blank)
When entering new data, I don't want to create another entry if I already have this item in inventory. I'd like to get a error message that says I already have this item (this way I can just go in and change the quantity) or something similar.
I tried looking around the forums, but didn't find anything that I thought would apply to me. Any help or pointers would be greatly appreciated.