There is no more hair left to pull out of my head so
hopefully someone here can help me out.
I have built a master detail form using the ColdFusion
wizards for Flex Builder 2.
On the details page I have used combo boxes which are
generating an error.
When adding new records the combo boxes display the last
selection by default. This would not be a problem except, if the
user sees a correct selection in the combo box they will not select
it and when saved an error is returned. "The INSERT statement
conflicted with the FOREIGN KEY constraint".
If you re enter the data making sure to activate every
selection (eg. select John Smith from a combo box that already
displayed John Smith everything works great.