>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,
You can't do this with remote views. You need to handle this using SPT and (IMO) a stored procedure. The remote view can still handle the table updates but you need the more powerful/flexible SPT approach to handle this type of processing.

HTH.