Discussions

Record with most recent date in one table for each record in another table with the same parent

  • 1.  Record with most recent date in one table for each record in another table with the same parent

    Posted 15 days ago
    Edited by Tate Forgey 15 days ago
    I've got a tricky request I'm hoping folks can help me with.

    I have a patients table. Related to that I have a patient tests table with test dates.  There will be new data containing patient treatments that has a date and a type. I was naturally going to create a table for that and relate it to the patient table. The request is that for every separate test a patient has I identify the most recent treatment and calculate the number of days that occurred before the test. 

    I had some "blunt force" ideas about how to get at this using summary fields on the patient, but I feel like there should be a more elegant way. Thanks!


    ------------------------------
    Tate Forgey
    ------------------------------