How to populate field on one table from field on another table

[chrish5]

Hi. I can use some help coming up with a script that auto populates a field from one table based on the field on another table.   I've put together scripts before that populate a field based off another field but they've been on the same tables.   Trying to cross tables like this is proving challenging for me.   Here is the details of my situation.

On the catalog task form, I added a new string field called City (u_city) This is on the Catalog Task (sc_task) table.     On the same catalog task form I have another field (reference field) called Requested For (u_requested_for) that is coming from the Requested Item (sc_req_item) table.   I want to populate the Cityf field with the city of the customer in the Requested For field. So this is all happening on the catalog task that is created after a request is submitted.    

I hope I have provided enough information.   Any help would be greatly appreciatd.     Thanks!

[d_cammack]

Hello Chris,

If the city value is already stored on the user's record, I would simply add a field by dot-walking from your requested for value on the parent record.   Is the city value needed for anything other than setting the location where the service is to take place?

Best regards,

David

[chrish5]

David,

Yes.   That worked.   I didn't see the obvious and was trying to do this a harder way.   Thank you for your assistance.