Create a custom beforeSubmit script event that will trigger a search on member elements and fill in custom fields with the required data. I did a little testing and I'm sure this is not something that can be achieved with a simple local search. Creating this custom event should be simple enough if you have some knowledge in SuiteScript and Javascript format. In the beginning, although you should only use the "N / record" and "N / search" modules if you are using SuiteScript 2.0. Information about both can be found quite easily in the help.
source share