Get Inserted Record ID

Original illustrated guide. Check the framework and controls shown against your project; current task guides are listed in How-to guides.

Step 1

There are some cases where you need to get the inserted record ID, for example - use it in another insert step, filter a query, update some data in another table etc.

In our example we will show you how to use the inserted record ID in another insert step, which inserts data in another database table. The logic for accessing the inserted record ID is always the same - it doesn’t matter if you need it for filtering a query, updating record, sending an email or any other server action step.

We have our insert record action, with an insert record step. Right click the insert record step, to add your other step, which needs to use the ID of the inserted record:

We select database actions:

Then add database insert:

Open the insert options:

And add the table you want to insert data into:

Click the dynamic data picker, for the column you want to insert the inserted record ID:

Step 7

And in the dynamic data picker dialog, you will find the identity binding, under the first insert record step. Select it:

And you are done. Now the second insert record step will use the ID returned by the first step:

The same way you can access the inserted record ID in any other server action step, where you need it.