I'm building a DVD database. It's organized by title and then discs are organized within the title. This is done because there are several releases of some titles (i.e. the general release, a special edition, etc.).
So, I want users to be able to add to the database. But I'm stumped on how to relate a disc to a title. Users will need to add a new title and then they'll be required to add a disc. After they've created the title, I want another form to pop up that will force them to add a disc. The problem is that if they add a row to the title table, how can I call the auto-incremented titleid from the title table to relate their addition to the disc table to the proper title. I can add to the database without problem. But I need to be able to find the titleid to pass to the disc creation form as a hidden variable. I'm absolutely stumped. Can anyone help? Or offer suggestions for a different process?
