Seq Key counter that will not create BS records

Discussion created by kojmichael on Sep 20, 2013
Latest reply on Sep 20, 2013 by BruceHerbach

I am trying to figure out a way to have a Seq counter for my PK and have it as the default value BUT:


I need to be able to enter in a Invoice # and pull up a previous invoice without the system saying "Save current REC?"

I need it so that when i manually enter in a KEY and save a REC it does not try to OVER ride my KEY value and save a REC with its KEY.


Basicly guess it should operate as "I am suggesting that you use this KEY" since it is the next Key avail. And I wont overide your entry.


Any ideas? As I have tried several different ways to get it to work correctly and it just loves to fight me.