Design Help

[Joel Griffith]

Hi sorry for being so vague. IO started off with all my
ables havin the same primary key. I was wondering if you
had any suggestions. or examples relating to my prroblem.

I am using Employeeid for the main tabl not sure what to
use for the other our how to link them so that when I
click on a for button it opens and doesn't give me an
error message

An example would be appricated

Thanks Joel

 

[Jeff Boyce]

Joel

Your table structure really needs to serve your data structure. Any table
can have any primary key (a little too broad, but you get the point).

More info, please...

Jeff Boyce
<Access MVP>

 

[Joel]

Dear Jeff

I get what a primary key is but iam just not sure how to
late them so that on the main personal form you can click
on any one of the other forms and fill in te data for
that form.

Personal_Information - Primary key is Employeeid (Auto
No.)
Emergency_Information - Primary key is Emergencyid (Auto
No.)
Payroll_Information - Primary key is Payrollid (Auto No.)

Does the above information help. I whant to open
Personal_Information formation and be able to move to any
of the other forms at random. (I want all of the other
forms to be linked off the Personal_Information

Thanks Joel