relationship to mutiple tables

[is250sp]

I have a relationship in the Ticket object to display the Person.Displayname.  It has the following parameters...

Relationshiop: SC_REPORTEDBY_TO_PERSON
Child Object: PERSON
Where Clause:  personid = :reportedby

On the SR app, I added a textbox field with Attribute = SC_REPORTEDBY_TO_PERSON.Displayname and it works.  Now I want to display the person's Location.  The problem is that on the Person table, Location is stored as an ID value.  How can I do multiple joins to Locations table to get the location description?  The join would be...

where ticket.reportedby = person.personid
and person.locationsite = locations.description

[Ethen]

I think relationship1.relationship2.attribute_name should do the trick..
However I never did it.

[maurogrz]

as Ethen stated, you have to define a relation between PERSON and LOCATION and then use the relationship1.relationship2.attibute to show the "sub-related" value.
It works, I used this a few times......

Mauro

[Yesterday]

• PM Estimated Due Date whe... by canislupus [Yesterday at 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [Yesterday at 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [Yesterday at 12:26:23 pm]
• add user access by Sarbjeet.Jassal [Yesterday at 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [Yesterday at 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]