When do you want this to happen? On record creation? What if you have a manually entered value and then later the field the condition is based on has a value? Will the manual value be over written?
it's about two address sections.
the first address is the Standard used for mail.
the second address is for billing purposes, in case is is different than the mail address.
so ideally the billing address is taken over from the mail address. however, my users should have an Option to Change the billing address if necessary.
I've attached a mock-up.
addresses should be in their own table each with a seperate record that way the billing and standard addresses can be in any configuration. You might want to create a set of buttons that copy billing to standard and standard to billing
makes sense to me. I might try that. thanks kris