I have two Access 2010 tables shown below.
The NeedToWatch table is a list employees that need to watch a set of assigned videos. The HaveWatched table shows every employee that has watched one or more videos It also lists the titles of the videos that they have watched. A one to many relationship is established by dragging Employee ID to User ID. My question is, "How can I get a query result and or report that shows a list of every employee and the video(s) that they have watched?" Some employees will have watched zero, some all five and others somewhere between 1 and 5. Many thanks.
T: NeedToWatch
Name
Employee ID
Dept
T: HaveWatched
USER
USER ID
TITLE OF VIDEO
Bookmarks