3 Replies Latest reply on Feb 26, 2009 12:05 PM by ninja

    my remove list



      my remove list


      I have a database of email contacts. It contains two tables. Table one contains all the contact information and table two is my "Remove" list and they are related by the "Email" field in each. Table one has a field called "Email Status." I want the "Email Status" field to display whether or not a corresponding email can be found in the remove table. The "Email Status" field is defined as "Auto-enter Calculation replaces existing value, Evaluate Always." The calculation is "If ( IsEmpty ( Lookup ( Remove::Email ) =0) ; "Remove" ; "Email" )."

      This only works during data entry in the active table. I want the "Email Status" field to update all the records whenever new data is entered in the "Remove" table.

      How can I get Filemaker to do the calculation?



        • 1. Re: my remove list

          Howdy dahemac,

          welcome to the forum.


          You are using an autoenter, which is a data entry action

          and a Lookup, which is a discrete action that requires a launch.

          I think that these are your problems.


          Why not have the filed be a calculation field which is

          If ( IsEmpty ( Remove::Email )) ; "Remove" ; "Email" )

          and be done with it?


          Does this not work for some other aspect of your Dbase?

          • 2. Re: my remove list



            I did not understand about the calculation field type because when I selected it initially the options button was greyed out. So, I did not know how I was supposed to enter the formula.


            Thanks for the help.

            • 3. Re: my remove list

              Howdy dahemac,


              Glad to help.