This has to be the most stupid-easy question ever, but for some reason it's not coming to me of what the best way to do this would be.
In short, I've got a sort of internal review process going on with a couple different lists that rollup into a master list (permissions requirement is why it was done this way), the master list is something I enforce Unique ID's on because we want to only have one line item that just continually gets updated. Every employee would get a line item, the thing that isn't so obvious to me is how would be the best way to have a condition that checks if the item already exists in the "master list", I'm passing the unique ID back to each of these lists so editing them is no problem but I can't have both b/c it just errors out due to the unique ID field.
Hopefully that makes sense of what I'm trying to do, can't figure out the best way to put a condition in to simply CHECK if an item exists, if it doesn't.. I'd want to create a new item, otherwise I'd want to just edit the existing item.
Any help would be greatly appreciated, because I've searched the living crap out of this and am about to pull my hair out with the crappy ways I've been ATTEMPTING to do this.