Database design

[TC]

Joel, you need to say what is the primary key for each table.

Perhaps try reading:
http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC

 

[TC]

Have you read the article I suggested?

If not, you really should do that now, before you proceed. The article talks
about concepts that you need to understand *before* you write any forms or
reports; and indeed, before you even create any tables!

I'm off now for 24 hours, so ... good luck!

TC

 

[TC]

No.

The problem is that the original poster does not know what a primary key is.

TC

 

[Joel Griffith]

I have ane Employee database. with 4 tables:

tblPersonal_Information
tblEmployment_information
tblEmergency_Information
tblDriver_information

The Idea I have are all the tables be linked off the
tblPersonal_Information. I want to be able to fill in the
form frmpersonal_information and click on a button and
fill in the other bits of informations

I have really tried wit this but I am getting nowhere can
you plese help thank you in advance Joel

 

[Becky]

Hi,
well the problem you have is that they cant all be
connected to the one table. this means that there is a
many to many realationship, and this is not allowed this
will be why the information is not entering into your
table the way you want it to. The key is no duplicating
fields.

Hope this helps.

 

[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

 

[John Vinson]

I have ane Employee database. with 4 tables:

tblPersonal_Information
tblEmployment_information
tblEmergency_Information
tblDriver_information

The Idea I have are all the tables be linked off the
tblPersonal_Information. I want to be able to fill in the
form frmpersonal_information and click on a button and
fill in the other bits of informations

I'd suggest a couple of things. As TC suggests, you do need to get
clear what a Primary Key is: it's a field within a table which
uniquely identifies a record in that table.

Each Table should refer to an "Entity" - a real-life person, thing, or
event. How are these tables related? What real-life person, thing, or
event do you store in tblDriver_Information for example? How are the
tables related: does each Person have one single Emergency_Information
record, or might they have several?

If (as is typical) you have one-to-many relationships you may want to
base a Form on tblPersonal_Information and put Subforms for the
related tables.