Hi.. I am curretly developing on a site which has two dropdown lists which are linked to two database tables; one of which is 'station' and the other 'type'.
I have a third table called 'stores' which includes all the information, and has Type_ID and Station_ID as foreign keys.
Could anyone please help me with creating a search button that will search what is selected in both dropdown lists, and use this to display the relevent inforation i have in my 'stores' table?!
Is it possible to first look up the ID, so for example if Bond Street is selected in the dropdown list, could I look up the ID for this in the 'stations' table and then use this to get the information with this ID from the 'stores' table??
I hope this makes sense!! If not please ask any questions!
Any help at all will much be appreciated!!