I have not been able to find a link anywhere in the database between time card sequence and shift sequence. Does anyone know if this exists anywhere in the database?
Obviously I can query and get the most recent of each, but in one of our applications, it needs to be able to match the shift and time card from a previous day. We have a ranking query that works most of the time, but it breaks in some cases if the manager manually addes a time card.
Obviously I can query and get the most recent of each, but in one of our applications, it needs to be able to match the shift and time card from a previous day. We have a ranking query that works most of the time, but it breaks in some cases if the manager manually addes a time card.