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. 

Yes there are three different dimentions of an element namely,

Label
Element Name
BoundTo

BoundTo is the database fieldname. 

Bob, you are right, understanding this in the beginging will save a lot of troubles to many in the future.

Quote:

- I'd rather you said:
"I will eventually always remember that a layout element is only the mechanism to access the data from the field."

- After a long time of encouraging you to use "Layout elements" rather than fields on a form, you've hit the area where we are specifically talking about FIELD names!