Welcome to SPN

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

Sign Up Now!

Selection from dropdown box to update fields...?

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

  1. Brandon

    Brandon
    Expand Collapse
    Guest

    I know this is probably simple, but if how do you set it so that if one of
    the main fields is changed, the rest follow suit to match the record?
     
  2. Loading...


  3. Sprinks

    Sprinks
    Expand Collapse
    Guest

    Brandon,

    I'm sure what your asking by "main fields" or "the rest". Please provide
    more detail on what you mean, including the tables, fields, forms, and/or
    subforms. I can imagine of at least two scenarios; I'm sure there are others.

    If you mean, say for an Order Entry application, that if you change the
    Customer Name or Address in the Customer table, and you want this new name or
    address associated with each of their orders, you don't have to do anything
    IF you are only storing the CustID in the Orders table, and retrieving the
    name &/or address via a query.

    If you mean that you are going to change the primary key field of the
    Customer table, and you want to "ripple" that change through all of the
    customer's stored orders (where the Customer primary key is stored as a
    foreign key), this is done by creating a relationship between the two tables
    by dragging from the "one side" primary key to the "many side" foreign key in
    the Relationships window (Tools, Relationships). Then double-click on the
    join, and enable Referential Integrity with Cascading Updates.

    If you mean something entirely different, please provide additional detail
    of what you mean.

    Sprinks

    "Brandon" wrote:

    > I know this is probably simple, but if how do you set it so that if one of
    > the main fields is changed, the rest follow suit to match the record?
     

Share This Page