Can anyone provide me with sample script in VB or SQL that would
automatically populate certain linked tables with records matching the
record the user just added to the main table?

I think you need to be more specific.  What do you mean "records matching
the record"?  One is plural the other singular.  Is the dabase design
appropriate?  Why are you duplicating this imformation that already exists
in your system?

When someone enters a record in the main table, the Employee table, I want
the program to automatically save the key for that record in four other
linked tables that have the referential integrity set.  The problem I'm
having is that the entry person may accidently skip one out of a sequence of
entry screens, one for each linked table mentioned above.  If that happens
and a record is not saved in one of those tables, the query that they use to
view an employee's information all on one page will not return that record.

So essentially, I just want to save a "blank" record in the other four
tables, with the same primary key of course.

By the way, thank you for responding so quickly.