AnsweredAssumed Answered

Simple 'Price Look Up'

Question asked by keycrew on Jul 26, 2017
Latest reply on Jul 26, 2017 by disabled_brianb

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.

 

Thanks

Outcomes