Results 1 to 4 of 4

Thread: Field Design

  1. #1
    Join Date
    Jan 2003
    Posts
    54

    Unanswered: Field Design

    Is it possible to have 2 field in a table,
    and 1 is always equal to the other.
    Equal at insert and update.

    (This because, I want to have a duplicate field for a renaming and
    future abandon of the 1st one, new developpement will use the new field)

    Thanks for any help.
    Pierre.
    Pierre (Pl-Arts)

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Hmmm...well you could try this:

    Place a statement something like what is shown below into the 'Before Update' event of your data entry form:

    Me.Field10 = Me.Field1

    As records are entered Field10 will always be the same as Field1.

  3. #3
    Join Date
    Jan 2003
    Posts
    54
    No, I am not programming in Access language,
    and I do not want to do this by programming,

    I was just wondering if inside the Access DB design, we could affect
    a value to a field which will always be the value of an other field,
    at insert and modify actions.

    Thanks for your help.
    Pierre.
    Pierre (Pl-Arts)

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Nope. Like CyberLynx stated it will have to be done thru code of some kind (VBA or Query) ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •