AnsweredAssumed Answered

How do I auto enter data into a field dependent on content of another field in the record?

Question asked by JohnBaughman on Feb 6, 2012
Latest reply on Feb 6, 2012 by JohnBaughman

Title

How do I auto enter data into a field dependent on content of another field in the record?

Post

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.

Thanks

John

Outcomes