I am new to Knack and really loving all the customization.
I am using Knack for my machine shop business to add and track jobs.
The area I am having the issue with is adding different machining processes to each job.
I originally had a multiple select drop down menu to select all the processes involved.
I moved away from this because I am using the data to auto populate an Adobe PDF using WebMerge.
Perhaps I can program adobe to enter each process onto a different line, but I wasn't able to figure that out.
So I decided to add 10 separate drop downs to select each process on my form (see image below).
This allows me to populate my form great, but I am having all sorts of issues filtering my data this way.
The issue is the values are always changing in each field for the processes.
For instance, Job 1 requires Waterjet Cutting, CNC Milling, and Deburring.
So I select [Process 1] " Waterjet Cutting" [Process 2] "CNC Milling" [Process 3] "Deburring"
Well my next job I may select "Waterjet Cutting" in [Process 5], so I need to be able to filter data from [Process 1-10] for "Waterjet Cutting"
There has to be an easy way to do this, right?
Any help would be greatly appreciated.
Thanks in advance!