Search across more than one column with multiple search terms. Search for more than one term in the same field.

Search Companies

For example, if you want to search for customers based the town of Bath that came through the website (a custom field) you can enter the search term

Bath;Website

Use semi-colons to separate out the search terms.

Search Suppliers

For example, if you want to search for a plumber based in Hull from your supplier you can enter the search term

Hull;Plumber

Use semi-colons to separate out the search terms.

Search Products

For example, to search for part of an item code (e.g. 145) and ‘Green’  in the description enter

145; Green

Use semi-colons to separate out the search terms.

Search Multiple Times in the Same Column

For example, if you have a product code CHAIR_FG_145 you can now search for this by putting in:

CHAIR; 145

This will find any product code with both CHAIR and 145. This multiple search in the same column applies Customers and suppliers as well.