Can I validate a field to be not empty when another field contains certain value
Using filemaker 9 on a Mac (10.5.8)
2 fields, say: Price Paid (number) and Status(text)
I would like to be able to make sure the 'Price Paid' field is not empty if the status field contains 'Sold' - think this is possible but not sure how??
Thanks in advance