How do I get last record of Inserted rec if NOT using Identity col ? CUSTOM Query Insert using Sequences

[brad]

Have a look at this thread and video

Insert record then redirect with new ID

This video (9m.40s) demonstrates how to create an insert form for a database table and how to retrieve the new id assigned to that record and then redirect passing that new ID as a parameter.