Welcome to SPN

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

Sign Up Now!

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
     

Share This Page