In Dispatch form after fill the product name from the dropdown list add a script trigger(on object exit)
set field( target field,calculation result)...for product code
set field( target field,calculation result)...for job number
In the calculation field jsut put the function lookup and mention there the field where the data is to be bring.
write a script:
set var(x= produnt name)
go to stock
perform find with product name
set var(y,product code)
set var(z,job number)
go to original layout
set field (product code,y)
set field (job number,z)
the whole script is attached by trigger(on object exit) in product name field
Thanks for this, I'll Give that a go,
I'm not familiar script writing I will have to learn quickly it seems.
No script should be necessary for this.
If you have this relationship:
Stock::Product Code = Dispatch::Product Code
Then you can use the Looked Up Value field option for Dispatch::Job Number and Dispatch::Product Name to copy this data from the corresponding fields in Stock.