knfitz
asked on
How to browse through access data quickly
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?
Create custom queries in Access and link them to a form.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.