Adding Reference in Virtual Column

[Manish_Jain11]

Hello,

I have 2 tables - Orders and Jobs

Jobs have reference to the Orders.

Now I want to get the value from the " Production Status " Column from Jobs Table in a Virtual Column in a Orders . How do I do that ? I know I can add a column in my data source referring the Jobs and get the value using [Jobs].[Production Status] but I dont want to add an extra column in my database unnecessary . Is there another way out ?

In Detail, I am able to render the status using the inline views but I want in the main view ( ORDER LIST VIEW) and I also want to be able to filter the orders based on the production status.