Using Look-Up Field To Display Price
How do I set it up so that the corresponding price shows up in another field based on the item chosen in a look-up field or possibly two look-up fields?
Simple example: Item Color (look-up field #1) + Item Size (look-up field #2) = Corresponding price from the same record.