How do I auto enter data into a field dependent on content of another field in the record?
I am new to databases in general and FMP in particular. Please bear this in mind in making any suggestions.
I have created a simple database with FMP. I have a field named "Source" that I want to auto enter text into dependent upon the content of another field in that record named "id". If the content of field id is "01" then I want "Cash" automatically entered into field "Source". If the content of field id is anything other than "01" then I want "Check #" to be entered into the Source field. I suspect this should be a relatively simple thing to setup. But in my exploration I haven't been able to figure this out. I suspect this has to be set up as some kind of calculation field?
I would be very grateful for any help you might give me on this issue.