How can I get a script to work across two tables? I have a contracts table, a client table and an inventory table. On creating a new contract I need a script to go to the inventory table, find available inventory, select the next three available items, and insert them into my new contract. (I would subsequently need the script to mark as sold the items placed into the contract, bit I can deal with that later). I can´t get the script to pause on opening the inventory table. It flashes up momentarily then returns to the contracts table. Any idea what I´m doing wrong?
Any suggestion welcomed.