Re: Connecting Tables

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

HTH;

Amy

"James" <James@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C5F5911-C769-417C-A89A-A48B31EFDB1E@xxxxxxxxxxxxxxxx
>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" <FergusonTG@xxxxxxxxxxxx> wrote in message
>> news:Xns96DEB9CC55F20garbleme4455656@xxxxxxxxxxxxxxxx
>> > "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx> wrote in
>> > news:ehSSCVuwFHA.2656@xxxxxxxxxxxxxxxxxxxx:
>> >
>> >> "her point"... ;-)
>> >> https://mvp.support.microsoft.com/profile=f0750c82-5540-4eac-a041-05c95
>> >> e457287
>> >>
>> >> I'd make a fairly large, homely "her".
>> >
>> > I guess she meant it as a compliment..!
>> >
>> > Tim F
>> >
>>
>>
>>


.

Relevant Pages

  • Re: FileDialog browse button: how do you specify the default directory
    ... Access Code, Tips and Tricks ... > Guess I'll have to let you go your own direction, Amy. ... rather than allenbrowne at mvps dot org. ... >> HTH; ...
    (microsoft.public.access.formscoding)
  • Re: DateTime
    ... like knowing the difference between an integer and a string? ... HTH, ... Kevin Spencer ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Combining Two Columns of Data
    ... Apparently you have a reason for not doing the simple copy and paste. ... Knowing this will help someone in answering your question. ... HTH ... Otto ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Math problem
    ... look at the CInt() function. ... HTH; ... Amy ... > Why are you storing numbers in a text field? ...
    (microsoft.public.access.forms)
  • Re: Need help with code.
    ... HTH, ... > without knowing the value of everything it would be hard to see the ...
    (microsoft.public.dotnet.languages.vb)
Quantcast