The ability to use a dropdown box to select a file within an mysql database table. The dropdown box will populate with the file names relevant to the user. The rest of the information is then shown in a form. In total there are two mysql tables, the second related to the first. Note there is a one to many relationship between first and second table.
The form will need to be able to adapt when showing the rows from the second table. The information from the second table is shown within two group boxs. The first box will have either one or two rows of information. The second can have one, two or three.
The user should have the ability to edit a file and then either save, cancel or save as in the case were they want to save edited file under a different name. When in edit mode, a dropdown box should be visible within each group box, and dependent on selection the number of rows should change.
The user should also have the ability to delete a file from the database plus create a new file from scratch.
Table 1 stores 8 pieces of information, 6 of which are numerical. A further field stores the user_id.
Table 2 stores 4 pieces of numerical information plus a field containing a ID for relevant row in first table