Populate multiple fields from one table into another

[Jonathan_Braddi]

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.

[Tuur]

You can create multiple lookup fields based on one linked field. Then you can use the lookups in your formulas.

[Jonathan_Braddi]

thanks, not sure how I missed that Lookup field type.