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.
You can create multiple lookup fields based on one linked field. Then you can use the lookups in your formulas.
thanks, not sure how I missed that Lookup field type.