CHanging field names

  • Thread starter Thread starter Melissa
  • Start date Start date
M

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
 
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
Click to expand...

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!
 
Back
Top