Enter Find Mode 
Set Field [ Lines_Cust_Inv::product_num; globals::x_product_num ]
Set Field [ Lines_Cust_Inv::Date; Globals::date_low & "..." & Globals::date_high]
Perform Find 
Just make sure x_product_num is also a field with global storage in Nick's example script.
Hi, Thanks alot, works a dream !!
Just a question, why use the command 'Set Filed [...' rather than 'Insert Calculated Result[...'
Does Set Field not overwrite the existing data in the field Lines_Cust_Inv::Date ? as I need to preserve this vaule.
It will not overwrite data in the script example Nick posted as there is no data to overwrite. (In find mode, existing data can't be modified.)
Insert Calculated Result has two key differences when compared to Set Field:
- The referenced field where the data is to be inserted must be present on the current layout or the script step silently fails to work.
- You can use this step with the current cursor position to insert data without overwriting existing data in the field.
Generally speaking the "insert" script steps that insert data other than files and images are usually used for "enhanced edit" tools that rely on the cursor positions. Most developers prefer Set Field for all other such actions as removing the target field from the layout in some future edit of the layout won't cause the script to mysteriously stop working the way it will with the "insert" script steps.
Thanks for all your assistance
Have a great day (evening)