I
Ian
Hi All,
I'm building a db at work (work in a hospital) of interesting clinical
caseloads. To give the user an interface to search the records I have
designed a form with various combo boxes that give the user search options. I
also want to put a combobox on the form that lists different KEYWORDS to
search on. In the underlying table there are 3 KEYWORD fields as I thought it
would be easier to search for single KEYWORDS in separate fields rather than
try to split out upto three words in just one text box. So each patient has
upto 3 KEYWORDS in their record. On the form I want the combobox to give me a
list of ALL the KEYWORDS entered into the database. I have tried to construct
a SQL string to use as the RecordSource for the forms combobox but all I can
get are the entries from the first KEYWORD field. It's like I'm trying to get
the SQL statement to join the entries in all 3 KEYWORD fields for all records
in the db. Is this the correct way to do this and if so can you help with the
SQL construct. If not can you suggest a better method. It would also be
excellent if this list of ALL KEYWORDS used in the database does not contain
duplicates as many patients may have the same KEYWORD. If this is not do-able
I guess I'll just have the user enter their own KEYWORD and use "Like
KEYWORD" to search the KEYWORD fields.
Here's hoping someone has a solution. Many thanks in advance.
Ian.
I'm building a db at work (work in a hospital) of interesting clinical
caseloads. To give the user an interface to search the records I have
designed a form with various combo boxes that give the user search options. I
also want to put a combobox on the form that lists different KEYWORDS to
search on. In the underlying table there are 3 KEYWORD fields as I thought it
would be easier to search for single KEYWORDS in separate fields rather than
try to split out upto three words in just one text box. So each patient has
upto 3 KEYWORDS in their record. On the form I want the combobox to give me a
list of ALL the KEYWORDS entered into the database. I have tried to construct
a SQL string to use as the RecordSource for the forms combobox but all I can
get are the entries from the first KEYWORD field. It's like I'm trying to get
the SQL statement to join the entries in all 3 KEYWORD fields for all records
in the db. Is this the correct way to do this and if so can you help with the
SQL construct. If not can you suggest a better method. It would also be
excellent if this list of ALL KEYWORDS used in the database does not contain
duplicates as many patients may have the same KEYWORD. If this is not do-able
I guess I'll just have the user enter their own KEYWORD and use "Like
KEYWORD" to search the KEYWORD fields.
Here's hoping someone has a solution. Many thanks in advance.
Ian.