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?
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)
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)
That’s a great suggestion. I’ll try it out. Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.