This is my first time posting so I apologize if my format or terminology is off. I am creating digital requisition forms for a company and I am having trouble establishing my one form due to a faulty query. I want to add a field to my form so that when I input the MarketCode it returns the name of the Employee. When I add the connecting information to my query (MarketCode [PK], Buyers.EmployeeEmail [FK], FistName, LastName, EmployeeOrderNum [PK]) I receive a blank form. I do not know how to properly connect my Employee branch into the rest of the query. I have attached my ERD and I appreciate any help I can get on the matter. Thank you in advance.