Hi, In my job add I have these fields CustomerId, Customer_Name, LocationId and Order_Site_Address
On the job_add page I have the CustomerId field set up as lookup wizard
Table = customer
Link Field = CustomerId
Display field = Customer_Name
This is because we export the data to another application, but I also need to put the Customer_Name in the correct field aswell, so I have been using the Autofill.
I do the same with the LocationId
Table = sites
Link field = LocationId
Display field = site_address
This dropdown is dependant on....
Category control = CustomerId
Catagory field = CustomerId
This is because we export the data to another application, but I also need to put the Order_site_address in the correct field aswell, so I have been using the Autofill.
What I would like to do is have this happen as an event, so I can have fewer fields on my job_add page
So we would just select the customerId and the LocationId and save, then the event would take over similar to this
SQL
Select
CustomerId as Customer_Name,
LocationId as Order_Site_Address
But I am not too sure on how to go about this.
Any help please?
Thanks
Paul