I am enquiring if it is possible to create a combined entity without having to created a relationship to an existing entity.

I have the following entites.

Deal Record (Has foreign key relationship to User entity) -dealid -createdbyuserid

DealRecordDetails -dealid -creadtedbyuserid -recorddetails

User -Userid

I would like to add user entity information to the DealRecord details collection without having to create a strongly typed relationship from dealrecorddetails to the user entity.

Is there a way to create a new collection with both (merged) related entity information.

I would like to add user entity information to the DealRecord details collection without having to create a strongly typed relationship from dealrecorddetails to the user entity.

Why you don't want to create such typed relationship? IMHO you would save a lot of manual work if you make such relation. (BTW, are you using Adapter or SelfServicing).

Of course, you could also use DynamicLists (read-only) to send custom relations and fetch whatever combination of data you want.