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

Checkboxes that update more than one record

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

  1. Zara

    Zara
    Expand Collapse
    Guest

    Hello! I have several records in each of my tables with the same
    company name, address, Company ID, etc... with one or two fields that
    contain different data (Like username and password for a website). I
    am using Access as a way to keep the information on the companies all
    in one place (I import the updates from Excel weekly) and use
    checkboxes to track what items we have for each company in a physical
    file here in the office. We only have one folder for each company,
    though one company might be listed in the table up to 10 times. When I
    go to the first record for a particular company on my form and check
    the boxes to indicate that we have ex) "form A", "form D" and "form X"
    in the folder for them, I want the checkboxes for all of the records
    with the same company ID to update automatically. How do I accomplish
    this? Thank you for your help!!! -Zara
     
  2. Loading...


  3. jahoobob via AccessMonster.com

    Guest

    You need two tables. One with the company info, including your checkbox data
    and the other with the username, website, etc. data tied to the company info
    table by a unique ID number primary key. This is the advantage of a
    relational database (you have to store the data only once.)

    Zara wrote:
    >Hello! I have several records in each of my tables with the same
    >company name, address, Company ID, etc... with one or two fields that
    >contain different data (Like username and password for a website). I
    >am using Access as a way to keep the information on the companies all
    >in one place (I import the updates from Excel weekly) and use
    >checkboxes to track what items we have for each company in a physical
    >file here in the office. We only have one folder for each company,
    >though one company might be listed in the table up to 10 times. When I
    >go to the first record for a particular company on my form and check
    >the boxes to indicate that we have ex) "form A", "form D" and "form X"
    >in the folder for them, I want the checkboxes for all of the records
    >with the same company ID to update automatically. How do I accomplish
    >this? Thank you for your help!!! -Zara


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  4. jahoobob via AccessMonster.com

    Guest

    You need two tables. One with the company info, including your checkbox data
    and the other with the username, website, etc. data tied to the company info
    table by a unique ID number primary key. This is the advantage of a
    relational database (you have to store the data only once.)

    Try using Analyze to split your tables. I know it takes the fun out of doing
    it yourself but...


    Zara wrote:
    >Hello! I have several records in each of my tables with the same
    >company name, address, Company ID, etc... with one or two fields that
    >contain different data (Like username and password for a website). I
    >am using Access as a way to keep the information on the companies all
    >in one place (I import the updates from Excel weekly) and use
    >checkboxes to track what items we have for each company in a physical
    >file here in the office. We only have one folder for each company,
    >though one company might be listed in the table up to 10 times. When I
    >go to the first record for a particular company on my form and check
    >the boxes to indicate that we have ex) "form A", "form D" and "form X"
    >in the folder for them, I want the checkboxes for all of the records
    >with the same company ID to update automatically. How do I accomplish
    >this? Thank you for your help!!! -Zara


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200606/1
     
  5. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    Data should never be repeated in a table (for the most part). Check out
    "Normalizing" data in the Access Help (or other documentation).

    If data is mention only once then it only needs changed once and then it
    will effect everywhere the data get referenced.

    --
    Phillip Windell [MCP, MVP, CCNA]
    www.wandtv.com


    "Zara" <ZaraliciousZ@msn.com> wrote in message
    news:1150987242.447315.19920@p79g2000cwp.googlegroups.com...
    > Hello! I have several records in each of my tables with the same
    > company name, address, Company ID, etc... with one or two fields that
    > contain different data (Like username and password for a website). I
    > am using Access as a way to keep the information on the companies all
    > in one place (I import the updates from Excel weekly) and use
    > checkboxes to track what items we have for each company in a physical
    > file here in the office. We only have one folder for each company,
    > though one company might be listed in the table up to 10 times. When I
    > go to the first record for a particular company on my form and check
    > the boxes to indicate that we have ex) "form A", "form D" and "form X"
    > in the folder for them, I want the checkboxes for all of the records
    > with the same company ID to update automatically. How do I accomplish
    > this? Thank you for your help!!! -Zara
    >
     
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