Get Label Data From Two Joined Erp Data Tables S’abonner
I have linked to my ERP data tables for two of the fields I need, Part number and drawing revision from the job header table. I also need part weight from the inventory master table. The join link is to PN in both tables to get all the jobs from the left table, and the matching weight from the right table. I have two text box label prompts to scan the job number and job suffix from a work order. I want the paint line employees to scan barcoces for these two fields to bring in the part number, the drawing revision and the weight from the work order to the label from the table data. I need to print Part ID labels for all the parts that are painted from any given work order. What I got was that one label for all the jobs were going to print until I figured out how to cancel the print job. How do I tell Bartender to print 30 part ID labels for a specific work order- suffix combination and auto populate the PN, Part Rev, and part weight from the data tables? I prefer that they not have to select the job from a list, and that they not have to enter the master passwords to print their labels. There will be a date stamp, and possibly three manual entries in prompt dialog boxes in addition to the data table fields. I tried to open links to training videos I saw in the FAQ entries here, and the links didn't work. Any help with the job/suffix logic would be much appreciated. I don't understand what to do here. Thanks!
Vous devez vous connecter pour laisser un commentaire.