relationship issue for a DB

  • Thread starter Thread starter bob
  • Start date Start date
B

bob

Iam having a problem with trying to get tables in a DB to relate to each
other. Here are the tables Fireman info, Drill Info, and Drill attendance.
What I want to do is have the DB keep track of what drills that each person
is attending and then have a total for each month and a percentage of the
drills. here is what info is in each table.

The other piece to this is that I want to have a drill sheet that the
officers can make out and just place a number in a box and the name will
appear. I have the part where they make out the drill sheet for the topic
and where it was held etc.
It is the attendance part i cant figure out

it would make it easier to just to add their number into a box and have the
name appear next to it

Firemen Info Drill Info Drill
attendance
ID pk Autonumber ID pk Auto ID pk Auto
Fireman no Number Drill No Number Chief Number
First Name Drill Time Deputy
Chief number

if you need to whole thing let me know

Thank you for the help
bob
 
Bob,

Rearranged your tables slightly... also, removed spaces, makes less typing.
Now you can see how they relate to each other...

tblFiremenProfile
fpFiremenID (PK - Autonumber)
fpFiremanNumber
fpFirstName
fpLastName
fpFiremenTypeID (FK - relate to tblFiremenTypes)

tblFiremenTypes
ftFirementTypeID (PK - Autonumber)
ftType (Chief, Deputy, etc...)

tblDrillProfile
dpDrillProfileID (PK - Autonumber)
dpTime
etc...

tblDrills
dDrillID (PK - Autonumber)
dDrillProfileID (FK - relate to tblDrillProfile)
dFiremenID (FK - relate to tblFiremenProfile)
etc...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
Iam having a problem with trying to get tables in a DB to relate to each
other. Here are the tables Fireman info, Drill Info, and Drill attendance.
What I want to do is have the DB keep track of what drills that each person
is attending and then have a total for each month and a percentage of the
drills. here is what info is in each table.

The other piece to this is that I want to have a drill sheet that the
officers can make out and just place a number in a box and the name will
appear. I have the part where they make out the drill sheet for the topic
and where it was held etc.
It is the attendance part i cant figure out

it would make it easier to just to add their number into a box and have the
name appear next to it

Firemen Info Drill Info Drill
attendance
ID pk Autonumber ID pk Auto ID pk Auto
Fireman no Number Drill No Number Chief Number
First Name Drill Time Deputy
Chief number

if you need to whole thing let me know

Thank you for the help
bob
 
Gina,
I have a Excel sheet to show all the tables that I need. Would you be
interested in looking at it to see if there is a problem with it. also tell
me where Iam wrong

thanks
 
Bob,

You can send me the Excel spreadsheet... I will look at it today but
depending on my *day* job I might not get back to you right away but it will
be today!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,
I have a Excel sheet to show all the tables that I need. Would you be
interested in looking at it to see if there is a problem with it. also tell
me where Iam wrong

thanks
 
Bob,

Oops, go to my web page to get my eMail, I do not post it here because I do
not want spam!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,
I have a Excel sheet to show all the tables that I need. Would you be
interested in looking at it to see if there is a problem with it. also tell
me where Iam wrong

thanks
 
Bob,

I have sent you an eMail with a question, answer that and i'll be able to
finish up.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,
I have a Excel sheet to show all the tables that I need. Would you be
interested in looking at it to see if there is a problem with it. also tell
me where Iam wrong

thanks
 
Bob,

I have returned your Excel workbook with a new tab!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,
I have a Excel sheet to show all the tables that I need. Would you be
interested in looking at it to see if there is a problem with it. also tell
me where Iam wrong

thanks
 
Back
Top