What is the best UI/UX Design for updating existing value in a particular field or creating new value for that field against unique ID in DB from an Interface?

I have a use case in which there is master table for A Field which contains records of 3 other table's filed B, C & D as per below screenshot. Table A has a field that needs to be created or updated and for other fields B, C & D user can do same thing.

A Contains master data of all A, B, C & D and B,C,D are child tables.

Do I need to user custom picker field for this because field contains more than 1000 values for each.

Please suggest.