3 Replies Latest reply on Feb 1, 2013 8:10 AM by philmodjunk

    Auto-Enter data

    LorenaMusser

      Title

      Auto-Enter data

      Post

           I would like to create a field that auto enter's data if another field is equal to a certain value.  In my file I have a seperate tab for each:

             
      •           Home Address
      •      
      •           Work Address
      •      
      •           Church Address
      •      
      •           Mailing Address

           On the mailing tab I have field that is "Same As" set up as a radio button to choose either Home, Work or Church.  I would like the Mailing address fields to auto enter the data from the other corresponding address fields if the "Same As" field is ticked.  Otherwise I would like it to be blank so that a different address can be entered.  What is the best way to go about this?  in the Auto-Enter options I have checked the specify calculation and tried the following 2 formulas, niether of which work:

           If ( IsEmpty ( If (Same as = "Home" = Home Address 1 ; If ( Same as = "Work" ; Work Address 1 ; If ( Same as = "Church" ; Church Address 1 )))) ; "" )

           If (Same as = "Home" = Home Address 1 ; If ( Same as = "Work" ; Work Address 1 ; If ( Same as = "Church" ; Church Address 1 ; "" )))

           Any assistance would be greatly appreciated.  Thanks.