db help newbie

[superrob5]

Hey I am working on a db. I have attached the relationshp pic and the db:
Employee Table
EmpFirstname
EmpLastName
Address
Contact
etc.


Paperwork table
PaperworkId
EmpId -linked to employee
Physical (date)
PPD (date)
Training (date)



do I need to have inforce referential integrity.

I am not sure what to do.


The first form that I will have the user do is enter the employees informatoin.

Then have another form that will load the employees name and list the paperwork. how do I get the
names to automatically show up?

is there a sample db somewhere where I can see how this is done???

eventually I will need to be able to enter any amount of year and associate hours to it. I think I would
have to do this with a sub form. but where should I put the year and hours. in a seperate table.

for instance employee 1 1999 10 hours
2000 20 hours
2001 10 hours
employee 2 1981 10 hours
etc.......


Rob

 

[Pat Hartman]

northwind and orders are always good places to start. Here's a link to a post where I've listed links to the other Microsoft sample databases. They are well worth studying.

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=172177#post172177

 

[superrob5]

thank you so much