I am trying to create a label that fills in information from a database that contains product information (color, dimensions, etc). I can filter this database reliably down to a single record based on a three-digit "product code" in the middle of serial number generated upstream in the manufacturing process.
I have a user form where the operator scans the serial number, and manually enters other data that appears on the label. Since the SN appears on the label, the text box where it is scanned in is already linked to the label element, and I can't hijack that field for the query prompt directly.
Since the serial number is already being scanned in, I would like to update the query prompt from that field without requiring the operator to separately enter (and look up) the product code. I just can't figure out where and how to update the query prompt programmatically based on the serial number field being populated.
I've also tried just using a static filter based on a named data source, but I can't get the filter to apply at print time, so printing creates labels for every record in the database.
Any help pointing in the right direction is greatly appreciated.
Please sign in to leave a comment.