You shouldn't be creating a record in the other 4 tables unless there is a
real need for it.

The best way to keep the tables linked is to first join them in the
Relationships Window with Referential Integrity enabled. Next create a form
based on the tblProjID table. On this form put subforms based on the other
tables.

It's pretty unusual to have one table linked to 4 other tables in a
hub-and-spoke configuration. What is in the other tables?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Marsh" wrote:

In an Access 2007 db, I have 5 tables, with Proj_No the Primary Key field in
the main table tblProjID. It has 7 additional fields.
It will be benificial to have Proj_No in the other 4 tables as foreign key
fields. My question is, when a new Proj_No is entered into the main table
to create a new record, how can I get that entry (alpha-numeric) to cascade
to the other 4 tables, thus creating a new record in the 4 child tables.

Thank you
Marsh