I'm creating a form which collects information on up to five items at once (if the user wishes), things like serial numbers and prices etc. For each item the user wants to add to the form, there is additional row of fields. For example, if the user wants to input three items on this form, they would fill in "Item 1", "Item 2" and "Item 3". The serial numbers would be indexed as "Serial Number 1", "Serial Number 2" and Serial Number 3, and the same goes for the other fields. If and when someone wants to search for a document based on an item or serial number, they would have to search in each item/serial number field because the field they've searched in is just one of five fields that the data might be indexed in. What I want to know is if there is a way for me to create a field in the file cabinet which allows the user to search for a serial number and it searches the Serial Number 1 through 5 fields to speed up the search.
This isn't entirely necessary for a functional system but this would drastically drop off a lot of search time when searching for a document because the user may not know if they have the wrong serial number, they may have to check all 5 fields multiple times if they think they might have made a typo.
Thanks.
