Normalization and foreign keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an HR dbase with S.S.# as the primary key and info about a person's
position. I also have separate tables with S.S.# as the foreign key -- one
has emergency info, the other has pager and cell phone (i.e. state property
information), etc..

When I link 2 tables, I can click the "+" sign in my main table for a drop
down with more info (i.e. emergency info). However, I can only do this for
one "sub-table" at a time. What's the best way to link this so I can pull up
the main HR info, and take a look at emergency contact and state property
tables if I want to see the info in those? I'm trying to avoid one big table.
 
First of all, you can't do it directly in the table. You should create a
data entry form with a tab control that holds a sub form for each of the
child tables.
 
Back
Top