I am trying to build a query based on the following:
user enters a number in fieldA e.g. 123456
I then want another field to loop through a view and find the number of variations of this number.
All variants will be in the form 123456.1, 123456.2, 123456.3 etc.
I'm guessing I need to create some form of loop coupled with a lookup?
My view "ViewA" displays all number variants in column1
So what I need is when someone enters 67891
a lookup is performed on the view.... lets say it finds:
I want the field to return 6
I was toying around with:
k := wo_no + "." + n;
n := n + 1);
I'm not sure if I'm even close with this?
Hope this makes sense?
Thanks for any help!