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?