Creating a column based on the string value from another table

Hello! I'm having problems... among many, I am trying to create a column in a table that will collect the name from another table and add it into this column... Table 1 (Acc/Act/Comm/Web) Purch...