Would greatly appreciate some help with this, pls. Here's my table:
My_ID | YayMi | Veer1 | Panther |
-------+-------+-------+-------+-
1.jpg |8542888|1256934| 758692 |
2.jpg |698874 |8452360| 4356800 |
I've made a form where I have a drop down list of the "shops" and a text field to enter the file ID that they use identify my file. Then clicking the button will search my table using the entry in the drop down box plus the entry in the file number textbox to show My_ID associated with. For example, I select Panther in the drop down list, then enter 4356800 in the File ID field, click the button and I get 2.jpg as the result.
Thanks.
