• First you need to select first from a lookup field the TYPE OF PRODUCT,
  
• Upon that selection the next lookup field only show the PRODUCTS from that TYPE OF PRODUCT.
  Until here all is working fine.
  The next field "PRODUCT NAME" should automatically be field in with the data from PRODUCTS.
  So i need a script to copy the data from "PRODUCTS" field to "PRODUCTS NAME" field.
  
  With normal copy script it does not work as the data from the PRODUCTS field is a lookup field.
  
  Why do i need to copy this field, well when adding a new form for lets say placing the product in a different warehouse, i use a new lookup field to select that certain product but the when searching for that product no name appears, i can only select the product ID, and searching by name would be much easier.

Anybody any idea how to solve this.

Thanks,

Anthony