Skip to Content
0
Former Member
Jul 09, 2008 at 03:21 PM

Linking Groupname to a field in another table

25 Views

Hi

This is my very first post in CR forums I will try to explain what I need.

I want to make a report that displays for any given salesman the clients and their rent,

Salesman 01

Pedro | Jan | 30u20AC

What I did is having this result:

001

Pedro | Jan | 30u20AC

I want to replace the code of the salesman by the name of the salesman knowing that the salesman is in the same table as the client because the salesman is also a client but in a diferent level.

I wanted to put something like this in the report but I don't know how or where.

SELECT Name FROM Client WHERE Client.id = Contract.salesman

Can anybody help me?