Stimulsoft Business Intelligence System | Forum

Hi,
I am new in Stimulsoft and I need support in a specific topic.

I have 2 tables:
- Table 1: Users (it has UserID, FirstName, LastName)
- Table 2: Car authorized drivers (CarID, UserID of person#1, UserID of person#2)

I need to replace in table 2 the UserID of each person by his/her last name. I can get it done with USerID of person1 but I can´t do that for person2.

What should I do?

Thanks

Hello,

You can add relation between tables and then use:
Table2.RelationName.LastName
https://www.stimulsoft.com/en/documenta ... report.htm

Thank you.