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