[AccessD] Matching Names & Qualifications

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