AnsweredAssumed Answered

Flag 'newest' related record?

Question asked by Wimmachine on Aug 9, 2010
Latest reply on Aug 9, 2010 by philmodjunk


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?