Linking tables

M

Meme

How can I link different tables together, so I can receive the some of the
same information on 2 different tables?
 
K

Ken Snell [MVP]

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

Meme

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

Ken Snell [MVP]

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top