Add new employee to multiple tables in one form

[Mrs Dumm]

Where to start...

I am building a database to track various information about employees. I
have split all the individual pieces up into their own tables to maintain the
one-to-many relationships. However, when a new employee starts, I need to
add data to multiple tables - most of them children of the main
"tblEmployeeInfo" table. I'm working with forms on this to make it end-user
friendly. This would also help when I make the reports.

Tables:
tblEmployeeInfo
UMC_ID (pk)
FirstName
MI
LastName
Preferred_Name
Gender
MOB (month of birth)
DayOB (day of birth) I don't get the full birth date with the year so I
split them up
UMCDateHired
Status
DOT (Date of Termination)
ReasonTerm
Rehirable (Y/N field)

For the other info about the employee, i.e. what cost center they are in,
their Job Code, Evaluation information, warnings, what tests they've taken,
home address, and e-mail addresses, each subject is in its own table with an
AutoNumber PK for the record number, the UMC_ID as the PK, info particular to
that subject, an effective date and an end date (so I can maintain history).

There are other tables such as tblCity, tblState, tblCostCenters,
tblDepartment and tblMonths that are for various fields in the child tables
for info that doesn't change.

At first I created an individual form for each child table with the thought
that I would use the frmEmployeeInfo as the main form and each individual
form (i.e. frmEEWarnings, frmEEPositions, frmEECostCenters) as separate child
forms. This proved to be WAY to cumbersome for someone to be able to use.

I want to create a query that joins all the child table info so I can make
one child form that will all be joined by UMC_ID. The other problem is I
want to get some fields from some of the other tables (i.e. tblState,
tblCostCenter, etc.) so that instead of being the PK from the lookup table,
it shows the text - "5W ICU" instead of "6103". I tried using the Query
Wizard but apparently I made my joins wrong or something because I returned
no records. The other problem is from reading the posts, some joins are not
editable.

I wouldn't mind having someone look at the design of my tables, either, to
make sure that the design itself is solid.

I've been scouring the group for ideas/answers and have gone to every Access
website I can find but I'm either not finding the answer OR I'm not
recognizing the answer when I find it! I would appreciate any help I can get
especially since I have no one around here that doesn't give me bunny eyes
when I start talking about this stuff!

Thank you!
Alicia Dumm (yes, Dumm... I found a man "Dumm" enough to marry me!)

 

[S.Clark]

I would make one main form with multiple subforms(datasheet is fine), placed
on a seperate tabs of a tab control. It is a little cumbersome, but it is
what Access is designed to do.

I think you're making it harder than it is. Start with just one, and when
you get it nailed, start on the other children. The wizard can create the
first Main / Sub instance. From there, add the tab control, then the
subsequent children.