Populate multiple fields from one table into another


#1

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.


#2

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


#3

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