Your result will be the city from the child with that formula. You'll need a field on the customer record that pulls the ship city, then you can reference that in another field on the child customer (using similar case logic). Then you can pull that field into your transaction search. Or. You could do a customer search and join to transaction table and then pull the very first field from the parent using your same case logic joining to the parent.customfieldforshipcity