Checkboxes that update more than one record

[Zara]

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

 

[jahoobob via AccessMonster.com]

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

 

[jahoobob via AccessMonster.com]

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

 

[Phillip Windell]

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.