If you have a relationship
Customer --< Job
ie every Job "belongs" to one Customer
all you need is a script with
Set Field [ Job::SiteAddress_street1 ; Customer::SiteAddress_street1 ]
Set Field [ Job::SiteAddress_street2 ; Customer::SiteAddress_street2 ]
adapted to your actual field and table names, of course.
1 of 1 people found this helpful
If it's a repeating situation, which tends to occur in the majority of cases, you might define the Job's address fields as auto enter from the Customers address fields. So you get as default the contact's address and change it to something else if it's the case.
what would i do if the address is different though as when I change it on the jobs address fields it also changes it on the customers address fields?
autoenter means evaluating a different field on record creation, copying its value in the autoenter field then having a normal behavior i.e. doing nothing to original field you've copied data from when the value gets changed by the user.
How do I set up the relationship? Ive tried but it doesnt seem to be working...