Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Autofill FieldB based on FieldA Value

Discussion in 'Information Technology' started by Wayne Wengert, Jul 28, 2006.

  1. Wayne Wengert

    Wayne Wengert
    Expand Collapse
    Guest

    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?
     
  2. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    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?
    >
    >
     
  3. Wayne Wengert

    Wayne Wengert
    Expand Collapse
    Guest

    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" <schapel@mvps.org.ns> wrote in message
    news:ui6HLxImGHA.4100@TK2MSFTNGP05.phx.gbl...
    > 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?
     

Share This Page