Hello,
I am working on a new form to capture inventory used on job sites. I am trying to have the end user enter 3 data points about a given item and I am using cascading choice filters to narrow down their selection. First, it is manufacturer of the item, then model, then fitting size. After selecting these three, we should be able to narrow it down to a given stock number and I would like to populate that stock number for them. I am wondering what the best way to do this is. Right now I am leaning toward concatenating the three entered fields, and assigning each unique string to a stock number and using pulldata() to retrieve it, but that seems messy and not so forward-thinking for updating down the line. Is there a better way to achieve what I am after?
Thanks,
Damon
