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>
 
You must log in or register to reply here.

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

Similar Threads

How to export table from outlook into ms access table? 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to link single excel spreadsheet to multiple access tables 1
Import Excel 2010 table into Access 2010 - not listed as range 1
Linked SQL Tables 1
Link to excel table which has keys in both row and col headers: isthis possible? 0
Query design 0
Linking Access and Oracle Database 2

Back
Top