I currently have three tables; Customers, Vendors and Service Details. I'd like to know how to create relationships so that when information is entered into the Service Details table once, all the information can be viewed from within the customers table IE; From within the customers table I wanted to see the Vendor preforming the service and the details of that service. Also from within the Vendor's table I want to see the details of the service as well as the customer. The hierarchy of the tables are the Customer orders a service and the Vendor performs the service for the customer. Lastly, once I enter the information into the service table I would like the vendor and customer field updated while entering the service details. Any help would be greatly appreciated.