So I have a database for a catering company with menus and staff and orders (this is sort of relevant, I promise).
I am trying to have a query that displays the name of the staff member needed to prepare each menu item. In the menu table, they are listed by staff number. My staff table has their staff number as PK and then all of their relevant information.
When I construct a query with both tables (and I have set up a relationship between the staff# fields in each table), everything comes back blank.
Thoughts?