Show the working contact information of all employees. Create a query that includes Employee ID, First name, Last name, Branch office name, Office phone number (consistent with the branch office phone number), personal extension number and offices full address information.

So, all three of the employees should have shown up in the Query table. But it doesn't. I need help figuring out how to make it show up. I think it might have something to do with joint properties?

Clipboard Sort & Filter Records Find Window Text Formatting All Access... Tables BranchID Address Phone Click to Add (732) 764-5768 (212) 983-4908 (890) 234-9803 BRANCHOFFICE Name Zi B01 Central NJ B02 Manhattan B03 Southern California 456 Woof 12 5th Avenue 56 Wilshire Boulevard EMPLOYEE 10021 ZIPCODE 90210 New Record: 14-1 of 3 No Filter Search EMPLOYEE EmployeelD FirstName LastName Address Zip Phone xtension BranchIDClick to Add E0001 JonathanEckstein E0002 Erving E0003 Joanne New 457 Ivy Lane 4753 Fontana Road 235 12th Street 08854 (732) 464-3279 90210 (549) 086-9804 10021 (212) 908-3490 Snodgrass Poole 2278 Record: 1of 3 No Filter Search ZIPCODE Zip City State Click to Add 07101 Newark 08854 Piscataway NJ 10021 New York 90210 Beverly Hills CA 95601 San Francisco CA NJ NY Record: 1 of 5 No Filter Search Query1 EmployeelD FirstName LastName Jonatharn Phone Extension (732) 764-5768 (890) 234-9803 Name Address 0001 E0002 Erving Central N Southern California 8903 456 Woof 2309 56 Wilshire Boulevard Eckstein Snodgrass Record: 14 4 1 of 2 | No Filter | Search Query1 BRANCHOFFICE ZIPCODE EMPLOYEE Branch!D Name Address Zip City State EmployeelD FirstName LastName Address lp Phone lp Phone Extension BranchlD Field: mployeelD FirstName EMPLOYEE LastName EMPLOYEE Name BRANCHOFFICE Phone BRANCHOFFICE Extension EMPLOYEE Address BRANCHOFFICE Table: EMPLOYEE Sort: Show Criteria: or