Using Manage a database feature is a little confusing.
I translated a little QA database and then merged it into my application.
I added a few lines of programming and all worked well.
I then realized that the field element names did not conform to my self imposed naming convention of database Identifier + element Name. For example these were in my products database and element names were Id, Description , PartNum and I wanted them to be ProdID, ProdDescription, ProdPartNum
So I used Sdesigner
Manage a database
Manage fields
Change field name
field name
new name
Add to batch
Run Batch
(besides the already known problem of the wrong word of field instead of element) I thought that the selection Change field name would change the element name.
After running my batch I modified the code to reflect the new field names.
I reconciled and tested
It would not work now
Upon further inspection I found that Change field name actually changed the Bound to not the element name
After using Sdesigner to change field names one at a time all worked fine again.
Am I misunderstanding or misusing this feature ? ???
I thought I would share this to save others from making the same mistake I did.