Checkboxes that update more than one record

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11904-checkboxes-update-more-than-one-record.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11904
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

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11904
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11904
>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/For...ccess/200606/1

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11904
Try using Analyze to split your tables. I know it takes the fun out of doing
it yourself but...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11904


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/For...ccess/200606/1

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" wrote in message
news:1150987242.447315.19920@p79g2000cwp.googlegro ups.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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11904
> am using Access as a way to keep the information on the companies all
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11904
> 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
>