[2005] Design the rpt file involve more than one table

[flyingsea]

Hi,

I have one sql which involve 3 tables. My problems is how i need to design the rpt file so that i can show the data fields below

Table A
1)UserID
2)VehicleID
3)Place


TableB
1)UserID
2)UserDesc

TableC
1)VehicleID
2)VehicleDesc

so i want to show the result in 3 of them within this 3 table (MSSQL 2005)
===UserDesc ===VehicleDesc===Place

thanks for helping

[RobDog888]

I think your design may be flawed as you can have a single user with multiple cars.

You could create a subreport that will display the cars linked to the user.