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

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

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/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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>