Linking tables in Access

How can I link two tables within Access so that records entered into one are
automatically entered into the other?

"cipher" wrote in message
...
How can I link two tables within Access so that records entered into one are
automatically entered into the other?

You can't. That's not how related table work. A relationship can cascade the
update of a field with a unique index to a related field in another table or
cascade the deletion of a parent record related to a child table, but
relationships will not create records in related tables.

If you use a database engine that supports triggers (Oracle, SQL Server, etc.),
you could create an insert trigger that would do this, but even then it would be
a highly unusual practice.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

In article ,
says...
"cipher" wrote in message
...
How can I link two tables within Access so that records entered into one are
automatically entered into the other?

You can't. That's not how related table work. A relationship can cascade the
update of a field with a unique index to a related field in another table or
cascade the deletion of a parent record related to a child table, but
relationships will not create records in related tables.

If you use a database engine that supports triggers (Oracle, SQL Server, etc.),
you could create an insert trigger that would do this, but even then it would be
a highly unusual practice.



Yes, highly unusual and most often a poor design. When you want
information to "show up" in another place automatically, you should use
a query that returns records with certain criteria. Then you can use a
status field or something similar to have records appear in that query
at the right time, even though their data is stored in only one original
table.

If you need to have the fields presented with related information from
other tables, use queries to join them together.

Hope this helps,

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/AS...jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com

In keeping with the theme of the responses you've already received, "why?"
As in "what business need are you attempting to solve by having two copies
of the same record in your Access database?"

--
More info, please ...

Jeff Boyce
Access MVP

"cipher" wrote in message
...
How can I link two tables within Access so that records entered into one
are
automatically entered into the other?