Autofill FieldB based on FieldA Value

  • Thread starter Thread starter Wayne Wengert
  • Start date Start date
W

Wayne Wengert

I haven't worked with Access in some time and am trying to setup a table so
that when a row is added to a table, the value is fieldb is automatically
filled in based on the value entered for fielda. I thought that there was a
way to do this?
 
Wayne,

No, there is not a way to do this.

If you are using a form for data entry (tables are not usually suitable
for this purpose anyway), you could use macro or VBA procedure on the
form to effect this. But on the face of it, this would normally be
regarded as invalid database design. If one value is dependent on
another value in a database, it should normally be derived/calculated as
and when required for your data management requirements, and not stored
in a table. This is normally done in a calculated field in a query, or
in a calculated control on a form or report.

If that doesn't help, please post back with more details, with examples,
of the data you are working with and what you want to achieve.
 
Steve;

Thanks for the reply. do unstrand that what I want to do does not fit 3rd
normal form but have a simple need for a table to be used for a merge
operation and I was looking for an easy "convenience". As you indicated,
I'll probably just do a query.

Wayne
 
Back
Top