Discussions

Expand all | Collapse all

Displaying data from an unrelated table

  • 1.  Displaying data from an unrelated table

    Posted 09-15-2021 13:00
    I currently have a parent table "patients" with two child tables, "procedure authorization" and "appointments." These two child tables are only related through their shared parent table but I want to display appointment information on my procedure authorization table. I currently have a report link connecting the two, but this does not work for me, as I need to be able to at a glance see the appointment without having to click on a link. Is there any way to do this? I really appreciate the help, as this solution is eluding me.
    -Hunter

    ------------------------------
    Hunter Collins
    ------------------------------


  • 2.  RE: Displaying data from an unrelated table

    Posted 09-15-2021 14:18
    you can create a field on appointments which concatenates the fields together with all the relevant details in one field.
    If you want the results to be sorted by date, then I suggest that the first part of the string be in the format YYYY-MM-DD.

    Then use a Combined text summary field on the relationship to float up the appointment details to the Patient.  Then use a formula like this to convert it to a vertical list.

    SearchAndReplace(ToText([My Combined Text Summary Field]), " ; ", "\n")

    Then look that up down to Procedure Authorization.


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Displaying data from an unrelated table

    Posted 09-15-2021 14:21
    Thank you so much!

    ------------------------------
    Hunter Collins
    ------------------------------



  • 4.  RE: Displaying data from an unrelated table

    Posted 09-15-2021 16:04
    Everything is working beautifully except the formula to convert to vertical list. Am I putting it in the wrong place?

    ------------------------------
    Hunter Collins
    ------------------------------



  • 5.  RE: Displaying data from an unrelated table

    Posted 09-15-2021 16:09
    Edited by Hunter Collins 09-15-2021 16:11


  • 6.  RE: Displaying data from an unrelated table

    Posted 09-15-2021 16:42
    The formula would be on the Patient Record.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------