Linking Records in the same R5OBJECTS table issue

[cbyrne]

Hello,

I have never come across this before.  I have a cloned screen from the R5OBJECTS table both with different OBJ_CODES.

The screens are called Communities and Assets, the obj_code for communities is called Location and the obj_code for Assets is called Asset.

I have a join from Asset to Location and want to show a report in one list view.

Is this possible or am I being really stupid?

Many Thanks

Chris