We are required to log the serial numbers of parts for a new type of job we have taken on.
Currently we have a lookup field for the part and a separate field for the serial where we will scan the barcode for entry. We then press a save button which has a script for a data transaction to update the part_usage table.
The issue we have is that the serial number needs to be recorded on the part_usage_serial
This would require a separate transaction but the pu_id from the first transaction would be required as a key to link the tables.
Also because the part is flagged as having a serial number the original transaction fails.
In the smart client when you enter the part_usage a box pops up to enter the serial number and it all works.
How do I achieve this on the mobile application?