Parent Table Staff Number List
Field Assigned To
Linked Doc Type Staff Number Assignment
Linked Field Name is FSS Number
I would Like when staff number is assigned in Staff Number Assignment it changes the Field Assigned To to that record in parent table of Staff Number List.
so can create filter to hide once assigned staff number so cannot be assigned twice