Hi all,
Im starting to build a database workbook for our machine shop that has items we order from different vendors/type of product/cost of product/item number ETC.. This will end up having many entries in it. In very simple terms i want to search thru this list with a "Search box" that will auto populate (or filter) AS i type showing only the items that match the "keywords" I type in the search box. What i would really want is that the order of keywords doesn't matter, nor case-sensitive, and it can contain numbers/text and even decimal points, because that is how i want to filter out items. Below is a small example of what im trying to accomplish:
<tbody>
</tbody>
<tbody>
</tbody>
Any ideas?
Im starting to build a database workbook for our machine shop that has items we order from different vendors/type of product/cost of product/item number ETC.. This will end up having many entries in it. In very simple terms i want to search thru this list with a "Search box" that will auto populate (or filter) AS i type showing only the items that match the "keywords" I type in the search box. What i would really want is that the order of keywords doesn't matter, nor case-sensitive, and it can contain numbers/text and even decimal points, because that is how i want to filter out items. Below is a small example of what im trying to accomplish:
A | B | C | D | E | |
1 | Product: | Diameter: | Overall Length: | Cost: | Item number: |
2 | Endmill | .25 | 5 | $37.00 | EDP9900 |
3 | Endmill | .375 | 5 | $45.00 | EDP7888 |
4 | Drill | .25 | 5 | $3.00 | EDP112222 |
<tbody>
</tbody>
keywords i "search" | Result of search of data above | |
Search Box: | endmill | row 2 and row 3 |
Search Box: | endmill .25 | row 2 |
Search Box: | .25 | Row 2 and row 4 |
Search Box: | 5 | Row 2, row 3, and row 4 |
<tbody>
</tbody>
Any ideas?