Find Matching records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guy

I have a problem - This is it, I am trying to match Contractors who have the correct skills and experience to a list o f vacancies in my database. The problem is th etable that contains the Contractor info contains the experience in text format while the Vacancy requirements are stored in a table with reference to a code for example
These are the tables I have -
TblVacancies - VacancyID is the primary ke
tblSystems - These are updateable records for systems requirements which has two columns the ID and the SystemName
tblSystemsRequired contains the info related to the system requirements for a particular vacancy. The records in this table refer to a Vacancy ID and the code relating to that particular requirement from the tblSystem tabl

The " contractor" table contains a column which is called SystemsUsed and can contain more than one system requirement eg " MIMS, SAP"

I am trying to match the relevant contractors with the Vacancy Requirements , Can anyone tell me the best way to approac this

Thanks in advanc

Paul
 
Hi,


Your design is far from the one assumed in
http://www.mvps.org/access/queries/qry0016.htm but may be the article can
give you some idea.


Hoping it may help,
Vanderghast, Access MVP



Dunderhead said:
Hi Guys

I have a problem - This is it, I am trying to match Contractors who have
Click to expand...
the correct skills and experience to a list o f vacancies in my database.
The problem is th etable that contains the Contractor info contains the
experience in text format while the Vacancy requirements are stored in a
table with reference to a code for example
These are the tables I have -
TblVacancies - VacancyID is the primary key
tblSystems - These are updateable records for systems requirements which
Click to expand...
has two columns the ID and the SystemName
tblSystemsRequired contains the info related to the system requirements
Click to expand...
for a particular vacancy. The records in this table refer to a Vacancy ID
and the code relating to that particular requirement from the tblSystem
table
The " contractor" table contains a column which is called SystemsUsed
Click to expand...
and can contain more than one system requirement eg " MIMS, SAP"
I am trying to match the relevant contractors with the Vacancy
Click to expand...
Requirements , Can anyone tell me the best way to approac this?
 
Back
Top