-
A Searching Problem
I have been developing a Access 97 database and come to a problem that I hoped someone may be able to help me with.
I have a table of people, (PersonID, name, address) and for each record I have a one to many relationship with another table containing information of these peoples skills (SkillID, PersonID, skill)
Now I want to search my database to find all the people who have a particular set of skills which is entered into a form.
I know, it sounds simple, but because I don't want to limit the number of skills that I am searching for at any time I have reached the limits of my ability to write queries. If there is anyone who can help me out on this one I would be very grateful.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|