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,


Reply via email to