Creating a page view with dynamic url based on parameters in node

I know this is probably a basic setup but just need some help getting started.

I am trying to work out how to create a dnamic url for a page based on a query result.

To explain.

1. A form is completed
2. The form submit creates a record in a table
3. On Success the user is redirected to a page which would contain a table displaying the record just saved to the database
4. The url format for the page: /admin/form_result/{database record id}

I gather i have to do the following:

• Pass the record id to a Parameter which is then used to run a query to display the correct record

• Something like https://example.com/admin/fromresult?id=12 and then reformat the url to look like this:

• https://example.com/admin/fromresult/12

I know kind of what I need to do but have no idea how to do this or where to start.

Any tips advice or exiting tutorials?

Many thanks
`