Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Selection from dropdown box to update fields...?

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

  1. Brandon

    Expand Collapse

    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. OP

    Expand Collapse


    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.


    "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?
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page