Is there any way I can have the selection of a drop down list create a record in another table and auto populate certain fields ?

Basically to forms with associated tables:

Main form is BAU Request and the fields in question are:

Service Requested

Product Type

Serial No

Asset No.

The second form is called "Repair Ticket" and has the following fields:

Product Type

Serial No

Asset No

Basically on the BAU Request form, if someone chooses "Hardware Repair" from the "Services Requested" drop down I want the data from the "Product Type", "Serial No" and "Asset No" to be copied into a new record  for "Repair Ticket".

I'm assuming this would be some code under the BAU Request form, Add, on success ?

Hope this makes sense

Kind Regards

MattP