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?