The challenge with adding Advanced Privileges to the Physician Info table is that it primarily contains biographical information, making it an unsuitable place for them. Advanced Privileges are more closely aligned with credentialing but are unique to the individual and the credentialing program, which is why I’m feeling a bit stuck.
Qrew LegendYou said that these Advanced Privilege "Differ from person to person." I interpreted that to mean that the actual possible values vary from person to person so having say 10 checkboxes on a Join table record would not make sense. How about if you put that same suggested multi-select field on the join table record and show it for only the relevant Credential.
If you go that route, I find that he appearance of a multi select field is pretty horrible in View mode or on a report., so I make a formula text field with the formula below to show the selections as a vertical list.
SearchAndReplace(ToText([my multi select field]), " ; ", "\n")
So you would add this field as a column on the embedded report.
