Ok, so I have a form that has multiple views, some read only and some editable. Each form has buttons to open the other forms in either edit mode or read only mode based on a field being set to either 1 or 0 and the current status of the form (so if the status is 'Awaiting Purchasing' and the check field is 1, then clicking the purchasing button opens the purchasing view in edit mode.
I have a button (Edit) to press that sets the check field to 1 on click and submitting the form sets the field back to 0.
Now here comes the tricky part! I have a list that contains Department (text) and Editors (multi-select people field). I need, within the Edit button, to check the status of the form, then check if the current user exists in the Editors field from the other list based on that status. If they exists then the Edit button will set the check field to 1, otherwise it won't.
Can anyone tell me a) if that is possible and b) if so, how to accomplish it?