I have 2 nsf. NSF A has 2 fields: EmployeeID(cannot be change) and EmployeeName(can be change). NSF B also has 2 fields: StaffID(cannot change) and StaffName(can be change). Both documents are created seperately. But the values are the same. EmployeeID=StaffID and EmployeeName=StaffName. Currently, the Save button in NSF A has the following code only:
What should I add before it to make any changes done to EmployeeName to be brought to StaffName? I know the EmployeeID can be used to lookup StaffID. Can anyone help me from the @DbLookup to replacing the StaffName value to making it saving the NSF 2 document? Thanks.