[AccessD] Matching Names & Qualifications

Not another table, I guess the Qualifications Held table is what has me
confused.

I have
Table one for Engineer (EngId, Eng)
Table two for Quals (QualID, Qual)

Table three (EngID & QualID)?????
Or would it be Qual & EngID?


-----Original Message-----
From: Mwp.Reid at Queens-Belfast.AC.UK
[mailto:Mwp.Reid at Queens-Belfast.AC.UK]
Sent: Saturday, March 15, 2003 7:28 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Matching Names & Qualifications


You will not have duplicates

Table one stores employees
Table Two stores Qualifications
Table three brings then together as Qualification held.

A simple  query will  tell you who holds which Qual. Why do you need another

table?

Martin

Quoting "Hollis,Virginia" <HollisVJ at pgdp.usec.com>:

> So even though I will have duplicate qualifications listed this is OK?
> 
> Senior Eng, eng name 1
> Senior Eng, eng name 2
> Reviewer, eng name 1
> Reviewer, eng name 3
> 
> -----Original Message-----
> From: Mwp.Reid at Queens-Belfast.AC.UK
> [mailto:Mwp.Reid at Queens-Belfast.AC.UK]
> Sent: Saturday, March 15, 2003 7:05 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Matching Names & Qualifications
> 
> 
> Create a Link Table
> 
> QualificationHeld
> 
> This is used to link the Employee to teh Qual
> 
> Martin
> 
> Quoting "Hollis,Virginia" <HollisVJ at pgdp.usec.com>:
> 
> > I need to make a table that lists the name of the engineer and their
> > qualifications. To do this should I make a table of qualifications
> and
> > another table of engineers - then how would I brink them together?
> Or
> > have a
> > list of qualifications and link to an engineer table?
> >  
> > tblQual (lists the qualifications and brings in the eng from the
> > engineer
> > table).
> > Senior eng, Me
> > Senior eng, You
> > Reviewer, Me
> >  
> > The final result they are wanting is if they select a qualification,
> it
> > will
> > list all the engineers with the selected qualification. Also, if
> they
> > select
> > an engineer, it will show what they are qualified to do.
> >  
> > Virginia
> > 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com