Drawing some multiple select options from another column

[Isabelle_Kirsch]

In my table, I have column 1 and column 2 with multiple select options for names. Column 1 has project leads (which include only senior managers) and Column 2 (which include both junior staff and senior managers).

I manually added names of junior staff in Column 2 but I was to customise it so that the names of senior managers are drawn from the options in Column 1.

Can anyone help?

[Jonathan_Letts1]

With this many people involved have you considered making it a linked record and linking it to a people table?

That would give you the ability to store additional information. And in a linked field you can limit selection to a view (managers vs staff)

[Isabelle_Kirsch]

Jonathan_Letts1:

selection to a view

That’s a great suggestion. I’ll try it out. Thank you!