Is this possible?

I want to be able to insert a single item into a database table that has many columns on one page, and then when submitted, be directed to another page that shows all the fields to add information in. In this case, I am creating an inventory app where you would add by selecting the type from a drop down menu. For example, computer, scanner, printer, book, etc. Then be directed to a page for that specific type of item to be added. I want the item selected entered into the database, and then on the next page have the fields that information needs to be entered into displayed. When the first page enters the type of item I want to add to the database, it will create the ID number for that item. This is what I want to get, so that I can have the next page display properly. How do I enter something, and then pull out the ID of the row that the item was entered into? Thanks, Mike