I'm looking for a means to do a simple price look up for items. I have two tables, an 'inventory' and a 'dispatch'. I'd like to see a price looked up (from inventory) and populated into a field (in dispatch), but only for current records, (not past). ie. Whenever a certain item number is mentioned in a field, it's price is pre-filled accordingly. I Understand I need to relate the two tables and possible run some conditional scripts, but am unsure how to proceed.