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 Schapel, Microsoft Access MVP

Wayne Wengert wrote:
> 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?
>
>

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

"Steve Schapel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 Schapel, Microsoft Access MVP
>
> Wayne Wengert wrote:
>> 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?