How to browse through access data quickly

Posted on 2011-10-10
Last Modified: 2012-06-21
I'm designing a database in access and right now I have 2 tables. One is customers and one is nodes. One customer can have many nodes. I want to be able to type into a form either the name of the customer or the name of the node and have all my other fields auto populate with the information. For example if I enter a customer name I want it to display all the nodes for that customer, location, etc. If I enter a node name I want it to display the customer name, location, etc. How do I get that kind of navigation?
Question by:knfitz
    LVL 27

    Expert Comment

    by:Jason Watkins
    Create custom queries in Access and link them to a form.
    LVL 84

    Accepted Solution

    Access has a lot of native features that allow you to do this, but quite a bit depends on your skillset and desire.

    You can design forms that will show you the data, but how you display it is another matter. In most cases, you'd build mainform/subform setups, where your "mainform" would be the Customer, and your subform would be the nodes (since a Node is a child of Customer). This is fairly straight forward.

    However, going the other way would require some more in depth work, since you'd have to work with filtering queries and such to show the Nodes associated with a Customer. I'm not sure how you're storing your data, but if it's like this:

    etc etc


    Then you can do a very simple query.

    If a Customer can belong to more than one Node, or if a Node can belong to more than one Customer, then you'll have more work to do.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    As a long-time IT Professional, the most important skill I have developed and consider to be my most valuable tool is Effective Troubleshooting. Step through my problem-solving procedure in this 10-step guide adapted from The Universal Troubleshooti…
    Email signature management is something that is often overlooked in many organizations or is simply not implemented effectively. Let's take a look at what methods are available for managing this important piece of corporate branding.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now