Welcome to SPN

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

Sign Up Now!

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
    >
     

Share This Page