Modifying "Search" Query in Contacts Web Database Template

[SethG]

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,

[June7]

Would have to include those other tables in the query design and link them to Contacts. The result will likely be a non-editable dataset. Also, the contact info will likely be duplicated because I expect Contacts has 1-to-many relationship with the other tables.