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.
  • ShawnRenn2's avatar
    ShawnRenn2
    Qrew Trainee
    8 years ago
    Agreed. I was worried the post was getting lengthy so I figured that would come next. Same setup as what you'd use for starting inventory.