Hello, my title might be misleading but I am creating a search script for our COO to search the db for all raw material sample test that are sent out. I have created the sample form resulting with 8 number fields for the sampleID's. ( sampleID1....sampleID8). Im using this script to find the values. The problem is I only want to enter one number in the search to find all related records. Each record has the sampleID fields from 1-8 on them so I currently have to have 8 different input boxes for each sampleID to search.
Im thinking I have to change the sampleID type of field so it can have multiple values. Im not sure how to do that. Help?