I need to know the ID before I save it because additions to child tables can be made before the parent table is saved. A way to get around the 2 additions is by using the flags.

If there is a reusable record that is not inprocess grab it and flag it as inprocess, that user now has a number, else you insert a new record flag it as reusable and inprocess and commit, you now have a number then the next user won't be able to get that record number.

If you then click save it unflags resuable and inprocess and you save it.
If revert is clicked you unflag inprocess and commit.

I don't know how to do this with a remote view of the SQL server data.

Tyler