All:
I am trying to create a training tracking database. I have a table that has the workgroups and the courses assigned to each group, a table with employees and the workgroups that they belong to, and a query that deletes all records and repopulates in a record entry master table based on any changes made. When I query in my form I bring up the needed records and can populate the dates. The records are then saved to a history table. My issue is that, while I can get the history table information, I cannot transfer that information to a master sheet to see overall compliance and/or to only see the latest records. Essentially, I want to see all assignments, completed or not, and on the ones that have been done, I only want to see the most recent completion. Does this make sense? I can't create a relationship between dates because that removes all records not existing in the history table. I'm guessing the solution is rather simple, but its just not coming to me. Thank you for any help you can lend.
I am trying to create a training tracking database. I have a table that has the workgroups and the courses assigned to each group, a table with employees and the workgroups that they belong to, and a query that deletes all records and repopulates in a record entry master table based on any changes made. When I query in my form I bring up the needed records and can populate the dates. The records are then saved to a history table. My issue is that, while I can get the history table information, I cannot transfer that information to a master sheet to see overall compliance and/or to only see the latest records. Essentially, I want to see all assignments, completed or not, and on the ones that have been done, I only want to see the most recent completion. Does this make sense? I can't create a relationship between dates because that removes all records not existing in the history table. I'm guessing the solution is rather simple, but its just not coming to me. Thank you for any help you can lend.