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.