Mutliple relations

Сonversation on different topics
Post Reply
jlorue
Posts: 126
Joined: Thu Apr 15, 2021 6:33 pm

Mutliple relations

Post by jlorue »

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
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: Mutliple relations

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply