Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

By selecting one record, others are automatically chosen?

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

  1. aheath15

    aheath15
    Expand Collapse
    Guest

    I am hoping to figure out how to better configure and 'fool proof' my
    database. For instance, a table includes various products and a boolean
    field that allows one to make selections. I am trying to figure out if it is
    possible to say "if product a is selected, then product c is automatically
    selected." I.e. when the boolean of record A is set to true, the boolean on
    record C is set to true, to prevent the user from forgetting a necessary
    product.
     
  2. Loading...


  3. Lynn Trapp

    Lynn Trapp
    Expand Collapse
    Guest

    I'm not sure I understand what you are looking for. Can you give an example
    of the data and what you are trying to achieve?

    --
    Lynn Trapp
    MS Access MVP
    www.ltcomputerdesigns.com
    Access Security: www.ltcomputerdesigns.com/Security.htm
    Jeff Conrad's Access Junkie List:
    http://home.bendbroadband.com/conradsystems/accessjunkie.html



    "aheath15" <aheath15@discussions.microsoft.com> wrote in message
    news:C7FBBB3F-F579-43F0-8AA3-2E6566FC1676@microsoft.com...
    >I am hoping to figure out how to better configure and 'fool proof' my
    > database. For instance, a table includes various products and a boolean
    > field that allows one to make selections. I am trying to figure out if it
    > is
    > possible to say "if product a is selected, then product c is automatically
    > selected." I.e. when the boolean of record A is set to true, the boolean
    > on
    > record C is set to true, to prevent the user from forgetting a necessary
    > product.
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    aheath15 wrote:
    > I am hoping to figure out how to better configure and 'fool proof' my
    > database. For instance, a table includes various products and a
    > boolean field that allows one to make selections. I am trying to
    > figure out if it is possible to say "if product a is selected, then
    > product c is automatically selected." I.e. when the boolean of record
    > A is set to true, the boolean on record C is set to true, to prevent
    > the user from forgetting a necessary product.


    Try an update query filtered by If A is true then set all the results to
    C = true.

    I am not sure of exactly what you want to do so sorry if this solution
    does not fit your problem.

    --
    Joseph Meehan

    Dia duit
     
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