autopopulate duplicate fields??

[Guest]

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

 

[Joseph Meehan]

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

Do you really need those two fields? If it is always going to be the
same, how about using a virtual filed created in a query?

If you really do need identical fields, you could just run a query from
time to time (like after any edit or addition) to set the second field equal
to the first, but really why?

 

[Guest]

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.