How to create multiple table relationships

[robi212]

Hi all,

Could anyone of you have solution for this ""HR.zip". I'm trying to create database for HR and all the tables has to be linked with on table "PFEmployees(one employee has to be linked with all other tables "beneficiary,disciplinary,caruser,otherinfo etc...). Is it possible to do it. Please look into attachement relationship for idea. Im really stuck with this.


Regards


Rob

[orange]

First - not everyone has 2007 or 2010 so they can not open your accdb.
Second - Are you familiar with Normalization? How about Entity relationship diagramming?
Here is a list of free video tutorials that may help.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html