3 Replies Latest reply on Feb 6, 2012 2:18 PM by JohnBaughman

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

    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