Relating Fields within the same record?

[zenman]

Can you relate 2 fields in the same record. Specifically how can I have input for Field one (Home Address), automatically transfer to a Field Two (Emergency Contact Address) without input into Field Two transfering back to Field One if the information is different?

[zincb]

Try using a button labeled "Use Home Address", next to the Emergency Address entry field.

When the button is pressed, it runs a script:

IF (not isempty (Emerg_Addr) )

Show Message (Do you really want to overwrite your Emergency Address with your Home Address?), 1 = No (default), 2 = Yes

IF (status (UserMessageChoice) = 1 )

Exit Script

End IF

End IF

Set (Emerg_Addr = Home_Addr)