Maybe it is late and I am not thinking straight, but I am in need of filtering a named browse layout that I have on a form and I am drawing a blank.
I have a set that consists of two tables. "mileage_tracking" and "vehicles". mileage_tracking is the primary table and vehicles is the child. mileage_tracking contains a bunch of records for multiple vehicles. In that table there is a Vehicle_id field. The vehicle table also contains the vehicle_id field as well as other details about each vehicle that is not in the mileage_tracking table. I have created a browse that will show me the entries sorted by each vehicle_id and then by date. I have created a form that has a browse object that uses the named browse that I created. I would like to add a couple of dropdowns on the form to filter the named browse that is on the form. The first drop would contain a single entry for each vehicle_id that is in the table, so if there are 50 records for vehicle 1 and 25 for vehicle 2 the drop down would only contain two entries (vehicle 1 and vehicle 2). When I click the dropdown I want it to filter the browse and only show the records for the chosen vehicle_id. I would also like to add a second dropdown to filter the Payer field. Same scenario as the vehicle_id drop down, multiple records that contain the same payer but only want to see one entry in the dropdown.
Any assistance or guidance would be greately appreciated.
I have a set that consists of two tables. "mileage_tracking" and "vehicles". mileage_tracking is the primary table and vehicles is the child. mileage_tracking contains a bunch of records for multiple vehicles. In that table there is a Vehicle_id field. The vehicle table also contains the vehicle_id field as well as other details about each vehicle that is not in the mileage_tracking table. I have created a browse that will show me the entries sorted by each vehicle_id and then by date. I have created a form that has a browse object that uses the named browse that I created. I would like to add a couple of dropdowns on the form to filter the named browse that is on the form. The first drop would contain a single entry for each vehicle_id that is in the table, so if there are 50 records for vehicle 1 and 25 for vehicle 2 the drop down would only contain two entries (vehicle 1 and vehicle 2). When I click the dropdown I want it to filter the browse and only show the records for the chosen vehicle_id. I would also like to add a second dropdown to filter the Payer field. Same scenario as the vehicle_id drop down, multiple records that contain the same payer but only want to see one entry in the dropdown.
Any assistance or guidance would be greately appreciated.
Comment