With every step baby forward, I run into yet another roadblock with this program. I am attempting to use queries and even though one would think that this procedure is straightforward, I am finding it's behavior to be very convoluted and unpredictable.
I have a simple query set up that appears to work when I use manually type in a value of a variable into a field; however, when I use script to 'Set Field Value (text)', the value that appears is NOT the value I had selected and the query then gives incorrect results. I can type in a value, for instance, 'SE-200', and it behaves properly but if I select the same value using 'Records From Folder' Open Input, the resultant value is a four-digit number ('1279'). Why is this occurring and how can I get BD to insert the value that I actually selected into the field?