Table and fields that link material number to condition type and rate

Hi guys, I need to know the field/fields that link material number to table that has condition type and rate. I want to be able to select the rate based on the material selected and condition type.

Thanks guys in advance!!