Hello,
I am using the Contacts Web Database template that you can download from Microsoft as a starting point for a staff roster that I am putting together for my company. There is a neat feature in the database that allows you to use a search box to find keywords in the databases contacts. What I want to do is to modify this so it helps my team better. Currently, the search will only look within certain fields such as "firstname", "lastname", "emailaddress", "jobtitle", etc. Searching across these fields is pretty pointless for our use. But the database comes with a separate table where you can enter "comments". I have converted this comments field to a "expertise" field and added another one called "responsibilities". These will basically contain keywords and short sentences that describe more about what an individual is working on.
I have attached 3 images to help someone to understand what I am looking. Basically, there is a query (image 1), which combines values from various fields into a single field. The search function then searches this field. I want to change what is in this field (called "searchable"). The fields that I want added are in multiple tables. The first field is called "Comment" in the table 'Comments'; the second field is called "responsibilities" in the table 'responsibilities'; and the third field is called "biography" in the table 'contacts'. Can anyone help me to redesign this query to include these three fields from multiple tables?
I have included screen shots of the macros behind the text box and search button that execute the search as well for reference.
Thanks everyone,