I just figured this one out... and I see that I am starting to develop some 'Brilliant Database logic'! My solution may not be the most elegant BUT it appears to work exactly how I needed it to.
This was especially challenging for me because 1.) I am very much new to Brilliant Database, 2.) the life of the course can be as little as one month or as long as five years (it varies from course to course) so the code must be dynamic, and 3.) only certain courses have the requirement to be repeated on some basis.
Since I only needed to see the most recent date of each training completed by an employee, I had to determine a way to capture the newest date for a course when an employee had taken the same course on multiple occasions (all completed training records are contained within a single folder). Getting the most recent date to the top per course per employee was easy enough by using a query to sort by course name, employee, and then date (descending). The challenge now was to ignore the earlier dates that the course had been completed. I did this by adding an additional (hidden) field to the form which was populated when the query was run - the field simply consisted of concatenating the employee's name and the course name. This new value gave me something to use as an unique field which I included in a second query. Running these two queries within the scripting pulled only the exact data (most recently completed date of training) that I was seeking. This synopsis is much more basic that what the total scripting does as only certain courses have to be retaken on some sort of recurring basis and the 'life' of the course varies from months to years, depending on the nature of the course itself... But, in the end, this solution appears to work.
James, I just checked out your scripting. This is certainly another method that I can include in my 'arsenal' of tools; however, each course may have a different 'expiration' date so this would not be able to pull the information that I was seeking. I really struggled with a method that would work for all the varied life cycles of the training courses. I certainly thank you for your help and ESPECIALLY for your earlier words of encouragement a few weeks ago when I was at the point of dropping Brilliant Database altogether! One day, hopefully one day soon I will be able to return the favor and answer a question for others here (yes, it will have to be a basic question, but a question answered nevertheless).[/edit]