updating several fields at once

[GlennC]

I have a group of 10 fields whose data will sometimes need to be be the same as another group of fields in the same layout, and sometimes not, depending on the value of another field. These are all within the same database. Is there a way I can automatically have the data copy itself from the first group of fields to the second when required?

Very grateful for help!

Glenn

[mun]

What would be some sample requirements?

[jasonwood]

Sounds similar to what I do for Billto/Shipto addresses.

I have a button to copy billto to shipto... it looks like this:

set field (shipAddress, billAddress)

set field (shipCity, billCity)

set field (shipProvince, billProvince)

set field (shipPostalCode, billPostalCode)

etc.

Would that be enough? or do you need it to update itself immediately when the value of this "other field" is changed?

[GlennC]

Thanks Jason, that does it.

I needed this to occur conditionally and so have inserted a 'case' statement within the 'set field' and it goes AOK.

Thanks for your help.