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

    my remove list

    dahemac

      Title

      my remove list

      Post

      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?

       

      Thanks.

        • 1. Re: my remove list
          ninja
            

          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
            dahemac
              

            Yes!

             

            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
              ninja
                

              Howdy dahemac,

               

              Glad to help.