AnsweredAssumed Answered

How to search multiple fields of same type with one field?

Question asked by dbanks on Feb 15, 2018
Latest reply on Feb 15, 2018 by BruceRobertson

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?

Outcomes