Hello, I was looking for a bit of direction on a project.
I had a table that has data and it is grouped by state counties.
I made a datasheet form from this. I will then put the database on a network so that people can audit the data through the form.
Since there are 88 counties in the data and the staff would like to look at only one county's worth of data at a time, I'd rather not make up 88 different tables or 88 different forms.
Can I set up a switchboard that goes to an initial form with a dropdown list of counties and then use the results from the user to do something like see the datasheet form with only the chosen county? Thank you for any input.
I had a table that has data and it is grouped by state counties.
I made a datasheet form from this. I will then put the database on a network so that people can audit the data through the form.
Since there are 88 counties in the data and the staff would like to look at only one county's worth of data at a time, I'd rather not make up 88 different tables or 88 different forms.
Can I set up a switchboard that goes to an initial form with a dropdown list of counties and then use the results from the user to do something like see the datasheet form with only the chosen county? Thank you for any input.