Hello, i've just signed up and I hope you guys can help a newly promoted database desiger. My boss wants me to set up some fields in a table to do some fancy dancing.. Here's the issue
I'm designing a form for data entry where the reps will enter customer information. We dont want typos, so I aquried (dont ask) a list of all cities and counties in the state we are working in. I created a table with the city and the corrisponding county... here's what I want to happen..
When the CSR selects the city, the appropriate county will populate under the county tab.
This will need to be used to filter leads by COUNTY for future reports.
So....
Help?
Please?
Officeboy
I'm designing a form for data entry where the reps will enter customer information. We dont want typos, so I aquried (dont ask) a list of all cities and counties in the state we are working in. I created a table with the city and the corrisponding county... here's what I want to happen..
When the CSR selects the city, the appropriate county will populate under the county tab.
This will need to be used to filter leads by COUNTY for future reports.
So....
Help?
Please?
Officeboy