choosing company, choosing that company's Part,appears the weight automatically

Hello Everyone,
I explained my problem in the files attached.
thanks a lot.

AttachmentSize
Delivery File.xlsx10.29 KB
Weight File.xlsx8.71 KB