Jeff,

I just noticed another problem with that method. If you open up two forms at the same time and then have each form add a new record they will both get the same number if you are not using an incrementing ID. I was using a tip from Jason that uses the SELECT MAX(somecolumn) AS MAX INTO CURSOR cSomeCursor.

Then you can use the MAX value as the Next ID. It seems to work really well. I also have another SP that uses a MASTER table to read the next ID value.

What happened using the MAX method was it gave both new View Records the same number. Then I saved one view and then when I saved the other view since the key was the same it Overwrote the first one!

Any more ideas?

TIA