CHanging field names

[Melissa]

hello

Is it possible to take for example, the "order entry" template database, and
change some of the field names to personalise it? if so, how, I have tried
changing all the "CustomerId" fields to a different field names on all
tables and forms, and keep getting error messages...

thank you

Mel

 

[Jerry Whittle]

Name Autocorrect is suppose to do this, but doesn't work all that well.

Rich Fisher's excellent Find and Replace is a much better tool. Still you'll
need to be very careful.
http://www.rickworld.com/

 

[John W. Vinson]

hello

Is it possible to take for example, the "order entry" template database, and
change some of the field names to personalise it? if so, how, I have tried
changing all the "CustomerId" fields to a different field names on all
tables and forms, and keep getting error messages...

thank you

Mel

One thing to consider: users of your application should never even SEE
fieldnames, or table or query datasheets.

You can put labels on Forms and Reports; these can and generally should be
different from the fieldnames, and can be more 'human friendly'. For example
if you have a field named ProductID, you can show the user a form with a combo
box (displaying the product name but storing the ID), with a label "Product".

So it may not be necessary to change the fieldnames; you'll be the only person
to see them!