I'm new to databases in general, trying to set up a db in Filemaker, learning from the help folder as well as this forum.
I defined a value list with a list of my products, I'd like to make the prices automatically appear in another field. For example, if I select '1 case' in the item field, I'd like '$100' to automatically appear in the price field. Then, if I select '2' in the quantity field, I'd like the price field to reflect that ($200).
Any help would be appreciated.