M
Meme
How can I link different tables together, so I can receive the some of the
same information on 2 different tables?
same information on 2 different tables?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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.
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>
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>