Automatically duplicate information from one cell to another?

[AC]

I have a Company form and a Client subform. Some of my clients work for one
or more of the companies. So some clients show up on multiple subforms. Is
there a way to link those subforms so that if I update a phone number for one
client it will automatically that clients' phone number on all subform where
that client is listed?

 

[Bob Quintal]

I have a Company form and a Client subform. Some of my clients
work for one or more of the companies. So some clients show up on
multiple subforms. Is there a way to link those subforms so that
if I update a phone number for one client it will automatically
that clients' phone number on all subform where that client is
listed?

If the table structure was correct you would not have to ask that
question, it will automatically happen.

you want a companies table, a clients table and a table with 2 fields,
the company ID number and the client ID number I'm pretty sure you are
trying to get by with only 2 tables.

Your subform's record source would be a query that joins the client
table to the new two-field table.

 

[AC]

I already have then linked by company ID and client ID, but just through two
tables. So, if I create the third table, that has company ID and client ID,
how should the three be linked? How will it allow me to link client
information that is duplicated?

 

[Bob Quintal]

I already have then linked by company ID and client ID, but just
through two tables. So, if I create the third table, that has
company ID and client ID, how should the three be linked? How will
it allow me to link client information that is duplicated?

You have a Companies table with no duplicates, and a client table
with no duplicates.

The third table is linked with the Company ID to the company table,
and the Client ID linked to the Client table. This table can contain
duplicate Company IDs, and Client IDs. You would set an index on
this table to CompanyID plus ClientID, no duplicates or primary key,
and a separate index for each of the two columns. A table like this
is often referred to as a junction table.

The usual form design for this is a form for the company info, and a
subform based on a query of the Client and the third table.

If you Google for Many-to-Many relationship MS-Access, you will find
lots of explanations.

Also Google on MS-Access Junction table

If the table structure was correct you would not have to ask that
question, it will automatically happen.

you want a companies table, a clients table and a table with 2
fields, the company ID number and the client ID number I'm pretty
sure you are trying to get by with only 2 tables.

Your subform's record source would be a query that joins the
client table to the new two-field table.