Displaying data from an unrelated table
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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendyou 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
------------------------------
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
------------------------------
Everything is working beautifully except the formula to convert to vertical list. Am I putting it in the wrong place?
------------------------------
Hunter Collins
------------------------------
------------------------------
Hunter Collins
------------------------------
- MarkShnier__YouThe formula would be on the Patient Record.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
