Hi all,
Worked with databases in a basic end for a long time but creating one for my company and got everything looking good pretty much other than this one issue. I know the solution is in the back of my head somewhere but I have been struggling with it for days now and need some assistance.
So this database needs 3 tables. 1 for customer business names, a second one that links actual employees at these companies that we talk to. We typically can chat with 3 - 4 customers at each business so would need a relationship between them tables. Finally a project table that basically incorporates all the details about a given project including the business name and the person that we will talk to at that company about a given project. I also have been asked by the boss to put first name and last name separately so I created a query to put the names together for the forms dropdown.
So far I have got the employees linked to the business names no problem. The issue is when I go to select the employee name in the project table it is not selecting only employees from the given business. It is bringing up any and all names.
The query includes the id number of employee, the full name put together and the company name.
Anybody able to help will be much appreciated as currently I am stumped.