Auto add record information

[Guest]

I have 4 tables. One table is the main table and the other 3 are tables are
information about records in the main table. The four tables share some of
the same fields. I would like to know if there is way to, that, in which....
If i add a record to the main table, a record would be added to the other 3
tables and then the fields that are the same between the 4 would
automatically populate.

 

[John Vinson]

I have 4 tables. One table is the main table and the other 3 are tables are
information about records in the main table. The four tables share some of
the same fields.

They shouldn't.

Databases use the "Grandmother's Pantry Principle" - "A place - ONE
place! - for everything, everything in its place". Storing data
redundantly is neither necessary nor beneficial; if you do, you'll be
certain to get update anomalies, in which the data in one table gets
changed and no longer matches the "same" field in the other table.

You're using a relational database. Use it relationally! Just store
the value of the main table's Primary Key in a matching foreign key
field in the related table (using a Subform makes this automatic), and
use a Query joining the two tables in order to see the data from the
two tables together.

John W. Vinson[MVP]

 

[dbahooker]

if you were using Access Data Projects; then you could use a trigger to
do this. It would take about a single line of TSQL.

the problem is that MDB is for ****ing babies and anyone that is still
using it should be FIRED and then SPIT UPON.

-Aaron