I have 2 tables
Table A has a listing of document ID numbers and names
Table B has a smart drop-down where I can select doc IDs from table A.
I would like another drop-down in table B to pre fill with the doc name associated with the doc ID from table A.
how can this be done? I tried using a apply filter and apply filter on matching criteria function, but cannot get it to work.