mailing......urgent

[Tech]

Hi there.

this is an urgent request. It's for a friend of mine, I offered to help, but of course, came to some problems, I hope u can help

in this database (on my server, please download)

ftp://temp:temp@techftpserver.co.uk/radjobs.mdb


I want to be able to create a simple query that matches up a candidate skills to a skills table, eg:

candidate 1 has skills of databases, and in the skills database/table, it has a reserved job of databases. i want this query.

however, it doesn't work it worked for another SIMPLE database, this one, just shows nothing

even if I just drag 2 fields from one table, nothing!

I have posted this msg and a bit more on this msg in the VBA section that contains the real question for VBA problem I am having, so please, this is not spamming...just trying to make things in the right order

thanks

 

[shay]

Hi

Not sure what you're trying to do but the reason your query doesn't return any records is:

In table Candidate, field ID contains S01, S02, S03

Table Vacancy, field ID contains J01, J02, J03, J04, J05, J06

Table Skill, field ID contains Access, Latin, Occam, Unix.

In your query you've joined the 3 tables on ID but there are no matches!

I suggest you rename your fields to ClientID, AgentID, SkillsID as appropriate to avoid this type of confusion.

hth

shay

 

[Tech]

cooooooooooooool

thanks alot, just a small favour, I really dunno how the database works to tell u the truth, I mean, how the additional stuff in the tables are done, what is the best way of going around and making the thing actually work

apart from that, U R A LIFE SAVER!

 

[Tech]

anyone? please??? how can I make the query work? it's a simple thing.....please?

 

[Tech]

I got everything else working, I just need this query to work, please, anyone? please!

it is suppose to match if the candidate has a skill that is in the vacancy table