Database design

  • Thread starter Thread starter TC
  • Start date Start date
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
 
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
 
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.
 
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
 
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
Click to expand...

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.
 
Back
Top