if Startdate,Time is selected from First Inputbox and Enddate,Time is selected from Second Inputbox and click the button then the system will display respective LotNos (Lot Numbers) along with minimum of LotDateTime.It will display all the LotNos’ and minimum of Lot start date from the Table for the selected date range. The user can select only one lot no from the “Lot Start” and “Lot End” list boxes.After selection of lots from both LotStart and LotEnd Listboxes then click on LotRange button,
The system will query the database(Table) for all the lots within LotDateTime column available in the lot start and lot end list boxes. The user can select only one option for lot start and lot end list boxes and also the system will have the validation on lot start date for lot start will be lesser than that of lot end list box. This feature allows the user to select the lot range for eliminate rows from the Table.
If the user selects lot range then the date range filter will be removed and lot start date range filter will be applied. If the user selects date range filter once again then lot range filter will be removed and capture date filter will be applied to the dataset(Table).
The selected filter will be visible to the user in current selection box.
I Think you undersatand my explanation.If you require any information regarding my requirement reply me.