Multiple related fields in a record from the same table

[Hproth]

I'm sure there is a simple solution to this problem, but I can't seem to figure it out!

I have a custom app that allows the user to write letters amongst other things. 

Each patient is linked to a GP and a Consultant, when writing a letter to a patient there is the option to CC both the linked GP and Consultant. However, occasionally another GP or Consultant might need to be CC'd in the letter (in addition to the ones already linked to the patient). So I would need the address of this additional consultant/GP to also be CC'd in the letter. For the life of me I can't work out a simple way to do this. 

Does anyone have any suggestions?

Thanks in advance.

 

[Steve Martino]

Well you left out a lot of details about structure and work flow, so it's hard to give a definitive answer.

When you are drafting the letter, how do you get any of the GP's/Consultants on the CC list?

You may need a popover with a picker list, probably another relationship, that shows all the GP's/Consultants who aren't already on the CC list, to add with a script.

[Hproth]

Hi Steve, thanks for your answer - i'll try provide some more info below with a better explanation.

There is currently a relationship between the patient and GP table. So each patient can be linked to one GP. 

Then there is also a relationship between the letter page and the patient. So when drafting a letter - you select the patient. There is then a radio button that states CC GP "Yes" or "No". If CC = "Yes" then the address for the GP that is linked to the patient appears at the bottom of the letter. This is displayed via a merge field on the letter.

However, I sometimes need to CC another GP into the letter - in addition to the one that is already linked through the GP - Patient relationship.

 

Hope this clears a few things up.

[Steve Martino]

I guess you could either assign the CC's first, or use the picker layout method with a script.