Re: Finding the natural key

A user is going to do some work on a particular day and then they are
going to record the fact that they spent 30 minutes, 2 hours or
whatever on a *particular schedule task* and want to report on it
later. Are you saying I should turn the 30 minutes into a date range?
The user won't specify that information - they will just know that on
Tuesday they spent an hour working on schedule task 1 on Monday and two
hours working on schedule task 2 on Tuesday.

I do like the Modules table idea, I am going to play with the table
design a bit and see how that works - Thanks. But I need to use some
combination of the Module and the line item in the module as part of
the key to uniqueness.

.

Relevant Pages

  • Re: Finding the natural key
    ... Tuesday they spent an hour working on schedule task 1 on Monday and two ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Students need I.D.
    ... >impossible to recognize design without a designer, ... and the money was better spent elsewhere. ... I suppose one might look at SETI as a kind of Pascal Wager: ...
    (talk.origins)
  • Re: Copied controls are in different location on form when viewed in design / form view
    ... I spent about an hour fumbling around, then gave up and sent the post, then kazaam, it hit me. ... Then I flip to form view and all the copied text boxes are about 10 cm lower than they were. ... I flip back to design view and it they go back to where I put them. ... I went through all the format properties but I cannot find anything obvious. ...
    (microsoft.public.access.forms)
  • Re: a (not so) simple problem
    ... I have a math problem regarding the proof of the uniqueness of the ... I have spent some weeks on it but have ... I'm sure I won't be alone in that. ...
    (sci.math)
  • Tube Mic Pre-amp
    ... a colleague of mine, here in Sydney, recently released this unit onto the ... professional studio market. ... He spent several years developing the design and contacted me a few times ...
    (rec.audio.tubes)