Filling fields based on another's content
I am trying to fill the contents of a field based on an entry in another.
For example, if the data in one field, called Transaction, is 'Transfer', then I want to automatically enter the text 'NO' in a field called Sales Tax. And, similarly, add a dollar amount to a field called List.
In Excel, this would be a simple If/Then... What is the pathway in Filemaker?
The If function can be used for this. Either in a field of type calculation or as an auto-entered calculation on a text (sales tax) or number field(list)
Which is best depends on how you've set up your database and what else you might need to do with these fields.