Many thanks, Jim. I am doing this exercise in Access and I realize that I made a mistake in filing the question in FP - I am using FP for other things on our webpage. In any event, I appreciate your questions back to me.
I have one table with the person's ID and other details - address, telephone, etc. I have a second table connected in a one to many relationship where the keywords for each person are located. It is tied together through the ID. If there are say 6 keywords for one person, that will occupy 6 records. I have set a separate table with all the keywords.
Right now, when I conduct a search I have a query which calls for the entry of the keyword being searched. This works fine except that I must type the particular keyword each time - with all the problems of typos, etc. If I could simply "pull down" the keywords from the combo box, that would simplify the operation considerably.
My next step will be to put this exercise on our website so two or three other colleagues could do some of the searching. However, I will need to do some more research and study before I undertake this part of the exercise.
I appreciate your thoughts and questions and look forward to your further response.
Norm.
----- Jim Buyens wrote: -----
Are you doing this in Access or in a Web page?
Do you have a table of valid keywords?
How do you store the keywords for each person? For example:
o Does the record for each person store multiple keywords
in one long field?
o Does the record for each person store one keyword
in each of several fields?
o Do the keywords for each person reside in a separate
table, with one record for each keyword for each person?
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
-----Original Message-----
I am using Access2002 and have a database with a couple
of hundred names and keywords entered which are adapted
to their resumes. Each person could have 8-10 keywords to
represent their skill levels. In the total database,
there are several hundred keywords. I want to do a search
using particular keywords to select out persons with
prescribed skills. Currently I am using a query with the
[Enter keyword] in the criteria. However, this
necessitates typing the keyword each time. I would like
to use a combo box which would list all the keywords. I
know this can't be done in a query. However, is there a
way of using a form with a combo box which would do the
search?
