Populate multiple fields from one table into another

I want to be able to populate a multiple fields from one table into another using a selected value. For example, I have a supply table with item name, price, quantity, etc. I want to link an item into a Budget table and pull the price, quantity in order to do some basic formulas.