autopopulate duplicate fields??

J

jake

Hi,

I have a form based on a single table which is used for updating info about
suppliers. For one reason and another I need each record to contain two
identical fields (one called CompanyName and one called Company but
containing identical data within the same record). Is it possible to minimise
the potential for error by having the data entered in CompanyName
automatically populate the Company field without typing it in twice? If so
how would I go about this?

Jake
 
J

jake

thanks for such a helpful answer. trust me that I do need two identical
fields. it has to do with the fact that i am redeveloping a databse that
someone else designed in a very haphazard way. it is quite large and there
are references to both fields in countless different places. The functioning
of my new design requires the two fields to be identical (which means that,
yes, they could be replaced by a single field) but it seems simpler to
auto-duplicate the record if possible than to root out every single reference
to each field (of which there are literally hundreds) and correct them.
 
Top