Users want to display fields from a Child object of a Related Object and use it as search criteria

Summary:

Business Requirement: Users want to display fields from a Child object of a Related Object and use the fields as search criteria in searching records.

3 Custom Objects Involved:

1. Hotel Client Contract (Related object with Hotel) (Object where to display the fields of Xref Object)

2. Hotel (Related Object with Hotel Client Contract)

3. Xref (Child Object of Hotel)

What Users want:

1. Users want to display values from Xref Object on Hotel Client Contract Object

2. Users want to search Hotel Client Contract Records using values from Related Xref and Hotel Objects.

Content (required):

Business Requirement: Users want to display fields from a Child object of a Related Object and use the fields as search criteria in searching records.