Connecting Tables

I was thinking the "her" thing was wrong, but I wasn't sure! I thought mabey
the name wasn't pronounced "Dwayne"!

Anyways, I see what you are talking about know. I don't know what I was
thinking making all of those fields. I should have known better. Here is
what I have now:
----------------------------------------------
tblSchedule
scheduleId(pk), positionId(fk), employeeId(fk), date (relationship to
tblDate that has the dates for one year. This will allow scrolling through
the dates with out having to create a new record)

tblPosition
posistionID(pk), shiftID(fk), PositionName, DefaultTimeIn, etc.

tblEmployee
employeeID(pk), FirstName, etc.

tblShift
shiftID(pk), ShiftName
----------------------------------------------
Is my table normalization correct?

"Amy Blankenship" wrote:

Absolutely. My husband and I met one of our dearest friends by sitting in
the front row of Rocky. After Frankenfurter had Steve on stage and sat in
his lap, he introduced himself after the play. And the rest is history...

-Amy

"Tim Ferguson" wrote in message
...
"Duane Hookom" wrote in
:

"her point"... ;-)
https://mvp.support.microsoft.com/pr...eac-a041-05c95
e457287

I'd make a fairly large, homely "her".

I guess she meant it as a compliment..!

Tim F

Note to self: set Outlook reminder to shave legs and mustache.


Ah, you'll be the darling of Seattle this week. :-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

Dear Lynn, et. al. :

Oh yes...I see the MVP summit is set for this week! I expect you'll all have
a blast gallivanting about! Don't worry, I'll do my best to help hold down
the fort while you are gone. Of course, I can only deal with the simplest of
questions; however, with many of you away, I *might* actually be able to
respond to the "simple" questions before you all jump on them first!

BTW, I hope there are hazing rituals for the new MVPs!! Being shaved bald,
perhaps? With pictures distributed? I've always been jealous of Jeff's thick
head of hair! g

Hoping you all have a great time!

Fred

"Lynn Trapp" wrote in message
...
Note to self: set Outlook reminder to shave legs and mustache.


Ah, you'll be the darling of Seattle this week. :-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

It's better, but hard to say if it's optimal without knowing more about how
you're using the data.

HTH;

Amy

"James" wrote in message
...
I was thinking the "her" thing was wrong, but I wasn't sure! I thought
mabey
the name wasn't pronounced "Dwayne"!

Anyways, I see what you are talking about know. I don't know what I was
thinking making all of those fields. I should have known better. Here is
what I have now:
----------------------------------------------
tblSchedule
scheduleId(pk), positionId(fk), employeeId(fk), date (relationship to
tblDate that has the dates for one year. This will allow scrolling
through
the dates with out having to create a new record)

tblPosition
posistionID(pk), shiftID(fk), PositionName, DefaultTimeIn, etc.

tblEmployee
employeeID(pk), FirstName, etc.

tblShift
shiftID(pk), ShiftName
----------------------------------------------
Is my table normalization correct?

"Amy Blankenship" wrote:

Absolutely. My husband and I met one of our dearest friends by sitting
in
the front row of Rocky. After Frankenfurter had Steve on stage and sat
in
his lap, he introduced himself after the play. And the rest is
history...

-Amy

"Tim Ferguson" wrote in message
...
"Duane Hookom" wrote in
:

"her point"... ;-)
https://mvp.support.microsoft.com/pr...eac-a041-05c95
e457287

I'd make a fairly large, homely "her".

I guess she meant it as a compliment..!

Tim F

Returned from a great Summit at Redmond... In honor of this thread (thanks
Amy) a fellow Access MVP created this shot.
http://www.hookom.net/images/IMG_1426.jpg

I'm glad they didn't gang up on me to hold me down, shave me, and dress me
up!

--
Duane Hookom
MS Access MVP


"Fred Boer" wrote in message
...
Dear Lynn, et. al. :

Oh yes...I see the MVP summit is set for this week! I expect you'll all
have a blast gallivanting about! Don't worry, I'll do my best to help hold
down the fort while you are gone. Of course, I can only deal with the
simplest of questions; however, with many of you away, I *might* actually
be able to respond to the "simple" questions before you all jump on them
first!

BTW, I hope there are hazing rituals for the new MVPs!! Being shaved bald,
perhaps? With pictures distributed? I've always been jealous of Jeff's
thick head of hair! g

Hoping you all have a great time!

Fred

"Lynn Trapp" wrote in message
...
Note to self: set Outlook reminder to shave legs and mustache.


Ah, you'll be the darling of Seattle this week. :-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

Is there a way I can go to this Summit thing next year? If so, I volunteer
to organize ;-)

-Amy

"Duane Hookom" wrote in message
...
Returned from a great Summit at Redmond... In honor of this thread (thanks
Amy) a fellow Access MVP created this shot.
http://www.hookom.net/images/IMG_1426.jpg

I'm glad they didn't gang up on me to hold me down, shave me, and dress me
up!

--
Duane Hookom
MS Access MVP


"Fred Boer" wrote in message
...
Dear Lynn, et. al. :

Oh yes...I see the MVP summit is set for this week! I expect you'll all
have a blast gallivanting about! Don't worry, I'll do my best to help
hold down the fort while you are gone. Of course, I can only deal with
the simplest of questions; however, with many of you away, I *might*
actually be able to respond to the "simple" questions before you all jump
on them first!

BTW, I hope there are hazing rituals for the new MVPs!! Being shaved
bald, perhaps? With pictures distributed? I've always been jealous of
Jeff's thick head of hair! g

Hoping you all have a great time!

Fred

"Lynn Trapp" wrote in message
...
Note to self: set Outlook reminder to shave legs and mustache.


Ah, you'll be the darling of Seattle this week. :-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

Sorry, this was an MVPs only event. I can share with you that Office 12 will
support PDF creation in all applications. You will be able to easily print a
report to a PDF file.

--
Duane Hookom
MS Access MVP


"Amy Blankenship" wrote in message
...
Is there a way I can go to this Summit thing next year? If so, I
volunteer to organize ;-)

-Amy

"Duane Hookom" wrote in message
...
Returned from a great Summit at Redmond... In honor of this thread
(thanks Amy) a fellow Access MVP created this shot.
http://www.hookom.net/images/IMG_1426.jpg

I'm glad they didn't gang up on me to hold me down, shave me, and dress
me up!

--
Duane Hookom
MS Access MVP


"Fred Boer" wrote in message
...
Dear Lynn, et. al. :

Oh yes...I see the MVP summit is set for this week! I expect you'll all
have a blast gallivanting about! Don't worry, I'll do my best to help
hold down the fort while you are gone. Of course, I can only deal with
the simplest of questions; however, with many of you away, I *might*
actually be able to respond to the "simple" questions before you all
jump on them first!

BTW, I hope there are hazing rituals for the new MVPs!! Being shaved
bald, perhaps? With pictures distributed? I've always been jealous of
Jeff's thick head of hair! g

Hoping you all have a great time!

Fred

"Lynn Trapp" wrote in message
...
Note to self: set Outlook reminder to shave legs and mustache.


Ah, you'll be the darling of Seattle this week. :-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

Dear Duane and Amy:

Nice to hear that the Summit was "great"! Thanks for the picture, although
it *is* a little tame...

Hey Amy! Next year, let's you and I crash the party! I'll bring some
shears - you bring the fishnet stockings!

Cheers!
Fred

"Duane Hookom" wrote in message
...
Returned from a great Summit at Redmond... In honor of this thread (thanks
Amy) a fellow Access MVP created this shot.
http://www.hookom.net/images/IMG_1426.jpg

I'm glad they didn't gang up on me to hold me down, shave me, and dress me
up!

--
Duane Hookom
MS Access MVP


"Fred Boer" wrote in message
...
Dear Lynn, et. al. :

Oh yes...I see the MVP summit is set for this week! I expect you'll all
have a blast gallivanting about! Don't worry, I'll do my best to help
hold down the fort while you are gone. Of course, I can only deal with
the simplest of questions; however, with many of you away, I *might*
actually be able to respond to the "simple" questions before you all jump
on them first!

BTW, I hope there are hazing rituals for the new MVPs!! Being shaved
bald, perhaps? With pictures distributed? I've always been jealous of
Jeff's thick head of hair! g

Hoping you all have a great time!

Fred

"Lynn Trapp" wrote in message
...
Note to self: set Outlook reminder to shave legs and mustache.


Ah, you'll be the darling of Seattle this week. :-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html

"Fred Boer" wrote in message
...
Dear Duane and Amy:

Nice to hear that the Summit was "great"! Thanks for the picture, although
it *is* a little tame...

Hey Amy! Next year, let's you and I crash the party! I'll bring some
shears - you bring the fishnet stockings!

hmmmm

:-)

How hard can it be to become an MVP? ;-)

-Amy

"Duane Hookom" wrote in message
...
Sorry, this was an MVPs only event. I can share with you that Office 12
will support PDF creation in all applications. You will be able to easily
print a report to a PDF file.

--
Duane Hookom
MS Access MVP


"Amy Blankenship" wrote in message
...
Is there a way I can go to this Summit thing next year? If so, I
volunteer to organize ;-)

-Amy

"Duane Hookom" wrote in message
...
Returned from a great Summit at Redmond... In honor of this thread
(thanks Amy) a fellow Access MVP created this shot.
http://www.hookom.net/images/IMG_1426.jpg

I'm glad they didn't gang up on me to hold me down, shave me, and dress
me up!

--
Duane Hookom
MS Access MVP


"Fred Boer" wrote in message
...
Dear Lynn, et. al. :

Oh yes...I see the MVP summit is set for this week! I expect you'll all
have a blast gallivanting about! Don't worry, I'll do my best to help
hold down the fort while you are gone. Of course, I can only deal with
the simplest of questions; however, with many of you away, I *might*
actually be able to respond to the "simple" questions before you all
jump on them first!

BTW, I hope there are hazing rituals for the new MVPs!! Being shaved
bald, perhaps? With pictures distributed? I've always been jealous of
Jeff's thick head of hair! g

Hoping you all have a great time!

Fred

"Lynn Trapp" wrote in message
...
Note to self: set Outlook reminder to shave legs and mustache.


Ah, you'll be the darling of Seattle this week. :-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conrad...essjunkie.html