Display names of another table

Question

I need help doing this realcion by which I have to join these two tables which I have data like:

TABLE: PERSONS

TABLE: OPERATIONS

and i want to

Answer 1

Select o.Operation, p.Name As 'Person in Charge',
   r.Name As 'Reviser', op.Name As 'Operator'
From Operations o
Inner Join Persons p On o.[Person in Charge] = p.ID
Inner Join Persons r On o.Reviser = r.ID
Inner Join Persons op On o.[Operator] = op.ID;

Answer 2

Hi @David Beltran

If you want to use a function in your report to do this, you can use the Lookup function, which retrieves the value for a name-value pair from a specified dataset. For detailed usage of Lookup function, you can check this link: Lookup function.

I simply did a test according to your request. First add the two data sets "ID" and "Operation". Then add the following table and add the expression.

Person in charge:
=Lookup(Fields!Persion_in_Charge.Value,Fields!ID.Value,Fields!Name.Value,"ID")
Reviser:
=Lookup(Fields!Reviser.Value,Fields!ID.Value,Fields!Name.Value,"ID")
Operator:
=Lookup(Fields!Operator.Value,Fields!ID.Value,Fields!Name.Value,"ID")

Preview:

Best regards,

Aniya