Re: new training database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 05/27/04 

Date: Wed, 26 May 2004 19:25:08 -0700

Please re-read my response. The third table I suggested only needs a
minimum number of fields, as you are only record "valid" pairs (THIS
employee and THAT course), plus any info specific to that pair.

Someone who signs up for 30 courses will have 30 rows in this third table.
Someone who signs up for one will have one. Someone who hasn't signed up
for any won't have any. 

-- 
Good luck
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: Default Value in different formating
    ... I agree with "grep's" posting. ... Please re-read my response. ... <Access MVP> ...
    (microsoft.public.access.forms)
  • RE: Manipulating .NotInList Event/Add Data to Combobox
    ... NUMBER, EMPLOYEE NAME, EMPLOYEE INITIALS - where columnEMPLOYEE NUMBER is ... Response As Integer) ... Dim strMsgText As String ... Response = acDataErrContinue ...
    (microsoft.public.access.modulesdaovba)
  • Re: Voting Buttons & Excel
    ... First, you have two sets of numbered lists in your response, so I'll compose ... you can only use the SenderEmailAddress propery with Outlook 2003. ... If quotes around dates work for Voting buttons, ... the Employee would ...
    (microsoft.public.outlook.program_vba)
  • Re: OT: Connecticut shooter pushed over edge by racism
    ... Were there massive errors in the police response that had it been ... Once he started shooting, is there anything the company could have ... What about the company's liabilty for the actions of an employee? ... negligent supervision and possibly negligent hiring, ...
    (rec.gambling.poker)
  • Re: Voting Buttons & Excel
    ... your code creates a new workbook alltogether which i donot ... Now, i saw that whenever someone sends a Voting response, i receive ... the Employee would ...
    (microsoft.public.outlook.program_vba)