Forum Discussion

HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
8 years ago

Flag most recent record in many to many details table

I?m building a medical surveillance application for employees working in a hospital environment, and are required to take a set of annual medical tests. The tables are: Test Types, Employees, ...
Ask about Quickbase functionality
HeatherBryant2's avatar
HeatherBryant2
Qrew Assistant Captain
8 years ago
Matt, thank you. That makes sense. Do you suggest I have the first entered Employee Test record as a Renewal record, or should only the recurrent test records live there?
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
For speed of use on entering the first test, you can use the normal test field for the 'original' date, and the renewals for everything after that.

Your 'expiration' date is going to be a formula field already so you can use the original if there are no renewals.

I think the users will enjoy that simpler approach.