Results 1 to 2 of 2
  1. #1
    ahmadu is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2018
    Posts
    1

    Residential Address

    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.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I recommend you post a few examples of your real data.
    In general/abstract terms to do what you suggest, you will need
    a table of "Areas" and a related table of "StreetAddresses" identifying which "StreetAddresses" are in which "Area".

    This is similar in concept to UN Geographic Regions and the Countries.

    Good luck.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-06-2018, 03:26 PM
  2. Replies: 7
    Last Post: 06-27-2016, 12:28 PM
  3. Replies: 2
    Last Post: 08-22-2013, 12:02 AM
  4. Replies: 1
    Last Post: 10-07-2009, 08:15 AM
  5. Input Mask for an IP Address and Mack Address
    By baksg1995 in forum Access
    Replies: 18
    Last Post: 06-23-2009, 12:33 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums