I have a problem. I am trying to streamline my consenting process for surgeries. I have Patient_Data table with unique patient information including a multivalue field for "operations" (ie one patient will get several procedures in one trip to the OR = Tracheostomy, Glossectomy, Neck Dissection). I have another table which relates each procedure to a multivalue field containing all the risks associated with that one procedure.
Now I have used queries to finally get it to where each patient is listed with their specific risks associated with their procedure (without duplications).
I then used concatrelated() to combine all these risks into one field to finally arrive at a query with only one row per patient with all risks listed serially in one field.
HOWEVER, I need more room. One of my records, the list cuts off with 3 risks not listed. I need more than the 255 character limit. Any thoughts?
Here is a sample of my Query... soo frustrating . I just need to list those risks horizontally for each specific patient.
Edit-
Reference: Allen Browne's website- http://allenbrowne.com/func-concat.html