I am trying to write some reporting for my application.
I have a table with customers, and a table with date ranges called period (start and end).
I want to display a recordset for the customer selected from a dropdown list and the period selected from a second dropdown.
so once the data is selected I want to be able to change the selected period for the same customer or change the customer for the same period.
I have the mySQL queries working just fine, I have tested my reports where I can pass $_GET's to and it works.
I just don't know how to put together the dropdowns from the other tables and the post to get it all working.
Any suggestions?
