Linking tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I link different tables together, so I can receive the some of the
same information on 2 different tables?
 
Your question is not clear.

If you mean, how can I obtain data from different tables and display those
data, use a query that joins the tables together.

If you mean, how can I store the same data in two different tables, don't do
that. That is not how to use a relational database.
 
No, I mean if I have a database with a tables named 1 and 2. I would like to
link these tables. I want to be able to in information in table 1 under some
fields, than the same information will automaticaly appear in table 2 under
the same fields.
 
This is not recommended usage for a relational database. "Store in one
place; use in many places".

Perhaps if you explain why you believe you need to redundantly store data,
we can suggest other ways to accomplish your purpose.

Otherwise, you'll need to use programming to run queries that would append
data into the second table based on the first.
--

Ken Snell
<MS ACCESS MVP>
 
Back
Top