Flag 'newest' related record?
Hello all. This seems like it would be simple but I'm having a case of the Monday's and can't figure it out.. I have a Contracts table related to my Employee table, which acts as you may expect: each employee can have multiple contracts. The contracts table contains start and end dates, and I need a way to flag the employee's 'active contract' i.e. the newest contract record based on the most recent start date. Any ideas?