Obviously doing something wrong..

I have three tables: Inventory,Transactions and Line_Items

Relationships:

Inventory:ItemID::Line_Items:ItemID

Transactions:TransID::Line_Items:TransID

I have a script that is triggered to create a new record within the Transactions table. It then displays a dialog box to enter the ItemID and an authorized name (any initials).

Once entered, it will lookup the name of the item and the Quantity on Hand. This seems to work fine. However, the last step is supposed to subtract one from inventory (qtyOnhand= qtyonHand-1). I consistently get a dialog box that states that the field is not modifiable...

Just as a test, I separated the subtraction steps as a new script. The only way this will work is for me to run script one, then click outside of any fields, then run script two.

What am I doing wrong?

thanks

UPDATE: never had a performance issue with these same files, but the script was finishing before it loaded the images of the item within the layout - at least that is what it seems. I removed the image field from the layout and all is well

Edited July 9, 201015 yr by Guest

Make sure that records are closed (use the Commit Record/Request script step) after they have been edited.

Set Field...

Set Field...

Set Field...

Commit Record/Request