I have a database that has tables in it state, county, practice etc..
When I do a search I search by the above the request has to search through all the records in the database. Is there anyway I can I can do a search so it will only look at the records for that state?