I am working on a project,i have hundred of residential address and this address are grouped to different area. For exanple
customer A is living in Stadium road, Customer B is ling in Waterline and Customer C is living in Woji for example. these areas according to their location is divided into Areas For example
Area 1 is Stadium, uyo strret,nk st
Area 2 is waterline, Membe st.
Area 3 is Woji,YKC St, WHATRE st.
etc
i want to develop a form so that if any customer comes from a particular street,the software will assign the area he is coming from based on the area already assigned to. I want the area to show in a text box immediately i type street within the catchement of that area.The area will automatically assign to the street above. I have 50 Areas with different streets under them.
Please i need help on how i will go about it.