Use the Data Assist insert record server behavior to save the form information.
In the Data Assist insert record behavior, There is a section of the First screen titled Session Variable, this allows you to select the ID column, and set the name of the session variable that will be used to capture the inserted ID value.
you would then need to add code after the Insert behavior to redirect to the results page using the session variable value, for example, if the session variable is named ItemID:
<?php
if($_SERVER['REQUEST_METHOD'] == "POST") {
header("Location: results.php?id=".((isset($_SESSION['ItemID']))?$_SESSION['ItemID']:"")."");
}
?>