I am trying to use the browse dialog to search for information that spans two different business objects, example JobCode and the Department Tables.

The first table JOBCODE has the following fields

JobID, Code, Description, Price, DepartmentID

The 2nd table Department has the following fields

DepID, Code, Description

When I use the search from the browse dialog, I want to be able to show the Department Description within the JobCode  business object instead of the DepartmentID field.