I'm hoping you can help me - I use EasyMorph a lot and am quite good at it but I can't figure out how to do this. I have created a simple example of my problem.
Two tables - Events is the parent and Diagnosis is the child.
For example you can see on the parent for ID1 (called A) there are three child records (Knee, Hip and Ankle).
What I ultimately want is an extra column on my Events table (say called Diagnosis) that for ID1 has the value Knee, Hip, Ankle. For ID2 it has Ankle, Foot, Wrist. For ID3 it just has Head.
How can I achieve this?
