Normalization and foreign keys

T

Tina

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.
 
L

Lynn Trapp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
sqlite-odbc write conflict 2
Primary and Foreign Keys 10
Access 2013: Form problem in reading data tables; relationship one-to-one 0
referential integrity and tables 4
Access Forms 3
Primary Key/Foreign Key 8
Why won't Access assign a Primary Key ID to my linked SQL Table? 2

Top