I currently have a table of PROJECTS (100s) and a table of RESPONDENTS (1000s). Could anyone advise how I could easily assign a batch of filtered RESPONDENTS (let’s say I filter to about 1000) to a one (or more) selected project/s from my PROJECT table? What’s the most efficient way of doing this?
Well, you could just add the wanted projects to the first respondent and then use the fill handle to drag the data down the records. Or even easier, copy that first cell, select all the other cells in the linked field and paste.