Thanks for the reply, I can see what you have done here but (there is always a but I'm afraid). DataAssist wizard you have to map the form fields to the database fields one to one. So in your example you gave we have two different fields writing for the same value.
What is the best way to get this into the DataAssist wizard using your method.
My original idea was that to change the text held in the other field with that of the select list regardless of the selection. That way I can map the 'other' field (visible or not) to via the DataAssist wizard.
Thanks again for the reply