Link to home
Start Free TrialLog in
Avatar of knfitz
knfitzFlag for United States of America

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?
Avatar of Jason Watkins
Jason Watkins
Flag of United States of America image

Create custom queries in Access and link them to a form.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial