I am trying to develop a front end to a database that will be used for entering information about the computer systems I take care of. It would be easy to do if it weren't for one problem. I want to list information about the drives that are in each system. There could be one, two, or 10 drives, so I want to have it generate a new table row for each drive. That I can do. The issue I run into is how best to create the interface. Right now I have a page where everything is entered on one page.
I have two tables in the database. One for the basic hardware information, and one for the volume information. The volume table has a field for the hardwareID so that I can tie the volumes to the hardware, and with a separte table, I can have as many drives as I want. The problem with this is that when I click on a hyperlink to open a window for adding a volume, I need a hardwareID to be able to tie the volume information to the hardware. The hardwareID is created in MySql when the information entered for the hardware is submitted, which hasn't been done yet. I could break this up into multiple pages, where I enter the basic information, and then I will have an ID created to use so that I can add the volumes, but this could get messy. Is there a better way of doing this? This is confusing to follow, I know. Here is a link to the page I am talking about so that you can get an idea of what I am talking about. http://bowser.homedns.org/assets/addasset.html About 1/3 the way down, you will see an Add Volume link that will take you to the addvolume page. Thanks in advance, Mike
