I have two forms:

Form 1 - Order_form

Form 2 - Booking_Details

In my booking_details form, i have a v lookup which links to the order number in Form 1 (Order_form).

This is a drop down option where the customer can select the Order number.

When a user selects the order numbers, I want the system to fetch relevant date to populate 2 fields in Form 2 . These fields are : Customer_name_bookingform  and Port_of_Discharge .

In Form 1 ( Order_form), the required date fields correspond to the following :

customer_name_bookingform   --->  Customer_Name

Port_of_Discharge -----> Port_Name

Could you help in creating a script for this occurs