Update Data Entry field based on number of labels and box number
How do I set the default value of a data entry field to display the sum of the box number field and number of copies needed ?
-
To perform maths functions you would need to use VB to achieve this. However there is no option to apply VB on a Data Entry Form or between displaying multiple forms. You can apply it before or after but not during the process.
0 -
We do something very similar, see if this sounds like something you want to go into further. I can send an example format for you reverse engineer.
Our customer asks for special package bag size and count based on what part they order. There is no way to save this information in our inventory system. So we made an Excel sheet with the our item number as the unique key (column 1). and the bag size, pack qty and other data on the sheet.
Then we have our label set to the SQL view (database) for the order data and did a table join to the Excel Data. A non-printable field on the label stores the order pick quantity, VB script does the calculations of ordered quantity / pack qty and sets the quantity of labels + 1 more label for the partial bag (if any). The label prints with the bag qty using VB on the label which is set to the pack qty except for the last label, it prints the remained (modulus) .
0
Please sign in to leave a comment.
Comments
2 comments