Dear all,

I have two fields: (this is for an education site)
1. School Board (values = a list of school boards) - can be edited by user

2. School Region (values = a list of regions) - cannot be directly edited by user.

I would like to know if it is possible to set the value of the School Region field based on the School Board field selected by the user. In other words, the value of one field determines the value of another field.

Example: User selects the "Halton District" School Board value which then auto-selects the "Eastern" School Region value.

The reason for doing this is we find that our users can identify their School Board without issue, but many don't know their Region. If they select the wrong region, it screws up out mailing. We need a separate field for the School Region so that we can sort easily for mail-outs.

Any assistance with this would be great - and I apologize if I'm posting this in the wrong place.

Thank you,
Chris.

Post edited by: porkleton, at: 2006/10/25 16:14