Search Page To Query Database And Display The Information
Posted on 2003-10-21
what im trying to accomplish is a page where a user can enter 3 search criteria's which are Clients, Run number, and Date.
Our list of clients can be hard coded because theres seldom a new one added also Run Number they stay the same, Date obviously can not be hard coded also im kind of wondering how I can make a date field on a webpage.
After this information is entered into the form and submitted it needs to filter out the search criteria and display it on another page like a data grid. So im guessing pass the search parameters threw the url have a page accept them and create a SQL query and display it.
Heres the database layout (fox pro)
Qualdata.dbc (database container)
within Qualdata.dbc there are two tables
Qualdetl.dbf (run detail information) Qualmast.dbf (run master information)
the fields for Qualdetl.dbf: the fields for Qualmast.dbf
so thats what im working with now as you can see by the fields these tables are beeing updated by a tracking system for trucks when a entry is made it enters it into both tables and is joined by the U_id field or Unique ID.
Any help would be greatly apreciated. Thanks