I'm having problems even approaching how to go about doing this particular form.
I'm making a DB app used for searching for company documentation on the company intranet. There are 6 products, therefore 6 tables (no relationships). Each table has one field called Description, which is a brief description of what the document is about.
My manager asked me to create a search form that will do the following:
"You can type in a keyword and search all the description fields in the 6 tables and then list all the documents that mention that keyword in the description. See a few of the documents might mention more than one product."
I've done an exhaustive search on Access help but I'm still floundering about what direction to take here. Can someone offer any starting points?
Leslie
I'm making a DB app used for searching for company documentation on the company intranet. There are 6 products, therefore 6 tables (no relationships). Each table has one field called Description, which is a brief description of what the document is about.
My manager asked me to create a search form that will do the following:
"You can type in a keyword and search all the description fields in the 6 tables and then list all the documents that mention that keyword in the description. See a few of the documents might mention more than one product."
I've done an exhaustive search on Access help but I'm still floundering about what direction to take here. Can someone offer any starting points?
Leslie
