Can you create a query like...

select callPK, extra fields,
   (select {probably a field list here} from Address where addresspk = callFK group by addresspk),
   (caller version),
   (report version)
from callertable
where blah, blah, blah

The idea here is that you select a single record from the caller table, where you join the fields (uniquely named) from the other tables right on the original select statment. The important part is realizing that the selects for the addresses would return only a single record for each callertable record.

These types of select statements are possible in Oracle, I just haven't tested them with multiple fields yet.


Good luck

Gordon



>I have a form that needs to display three addresses for a "Call". Part of the Call table looks like this
>
>CallPK
>LocationAddressFK
>CallerAddressFK
>ReportAddressFK
>
>What's the proper way to go about this? Seems like I would have to either create three instances of the address business object, or create three data views, but neither way seems quite right.
>
>TIA,
>Mike